Is Your Oracle Invisible Index REALLY Invisible?

(David Fitzjarrell) Invisible indexes are a nice addition to Oracle, since in general, the optimizer ignores them when generating execution plans. It appears though, that in 11.2.0.4 that isn’t necessarily the case since it can still ‘see’ the index statistics and thus will consider the index at run

Read More - Register for Free Membership