Invisible Indexes and its impact on Foreign Keys
Invisible Indexes on Foreign Keys can still be used by Oracle to prevent locking and performance
related issues when delete/update operations are performed on the parent records.
for more information read a very nice article by Richard Foote.
http://richardfoote.wordpress.com/category/invisible-indexes/
No comments:
Post a Comment