(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