Search SSWUG.ORG:



DATABASES

Indexing Foreign Key Constraints With Invisible Indexes (Invisible People) This is an off-site link.  Please review our Terms of Service for additional information.


(Richard Foote) In my previous post I discussed when deleting rows from parent tables, how Bitmap Indexes based on the FK constraint can prevent the expensive Full Tables Scans (FTS) on the child tables but not the associated exclusive table locks.

Read this article..







comments powered by Disqus