Invisible Index in Oracle 11g

In release 11g, Oracle introduced a new feature of making an index invisible. During the index creation, one can specify whether index can be visible or invisible. We can also alter index to be visible or invisible. Invisible index is ignored by optimizer when computing the plan for a SQL.

Read More - Register for Free Membership