Search SSWUG.ORG:



DATABASES

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


(Richard Foote) Franck Pachot made a very valid comment in my previous entry on Indexing Foreign Keys (FK) that the use of a Bitmap Index on the FK columns does not avoid the table locks associated with deleting rows from the parent table. Thought I might discuss why this is the case and why only a B-Tree index does the trick.

Read this article..







comments powered by Disqus