index

Invisible index in oracle database

Invisible index is introduced in oracle 11g. As the name suggest, this type of index will be ignored by database optimizer, as if it doesn’t exists. EXAMPLE: —  CREATE AN INDEX ( BY DEFAU...

Monitor Index usage to find unused index

WHY IS INDEX MONITORING REQUIRED? Keeping a lot of indexes on a table, can affect the performance of the transaction like insert, update, delete on the table. i.e if we are inserting a new ROW, a new ...