• Hi,

    You can create non-clustered (not unique) indexes, and can improve performance.

    If you change the setting from ANSI NULLS OFF to ON, you need to do Regression Testing.

    In my opinion, ANSI NULLS setting has to do nothing with Deadlocks..


    Kindest Regards,

    R