Saturday, August 31, 2013
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/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment