Invisible Indexes and Locks

Invisible indexes are useful to temporarily hide an index from the query optimizer. In this post, instead of explaining what invisible indexes are, I would like to show whether the database engine uses invisible indexes to avoid false contention caused by unindexed foreign key. Let’s start by creating two test tables with a relation (foreign key) [...]

Lesen Sie den vollständigen Eintrag unter http://antognini.ch/2008/10/invisible-indexes-and-locks/