• We have a filter index including WHERE MyKeyColumn IS NOT NULL on some of our FKey-supporting indexes - e.g. where we have an FKey on a User Defined Column which may not be used / may not be used much.

    Might be an idea to consider if the FKey candidate column(s) is Nullable or not?