Indexing Foreign Keys (Helden) This is an off-site link.  Please review our Terms of Service for additional information.

(Richard Foote) A recent question on an internal forum asked whether an index on a Foreign Key (FK) constraint designed to avoid locking issues associated with deletes on the parent tables needs to precisely match the columns in the FK. Could the columns in the index potentially be a different order or be appended with additional columns ?

Read this article...

comments powered by Disqus