Community

Invisible Indexes in Oracle 11g

(SBH) Invisible Indexes are another feature which was introduced in Oracle 11g. It is nothing but a normal index on tables whose usability by the optimizer is set by a parameter. Oracle optimizer would ignore an invisible index on the table if the initialization parameter OPTIMIZER_USE_INVISIBLE_IND

Read More - Register for Free Membership

Tags: