Invisible Indexes and Hints

Published 11 November 08 05:02 | Striving for Optimal Performance

In this post I would like to remove some misinformation about the utilization of hints with invisible indexes. Let’s start by providing you what two sources say about that topic: Oracle Database 11g: New Features for DBAs and Developers (by Sam R. Alapati and Charles Kim, page 132) “If you want the optimizer to take the invisible index [...]