TABLES WITH MORE THAN 5 INDEXES NOTES:
  • Owner - Owner of the table
  • Table Name - Name of the table
  • Index Count - Number of indexes

  • Over indexing can have an impact on Inserts, Updates, and Deletes
  • Large batch inserts can be slowed by indexes, you may wish to drop indexes before large inserts are done. Usually, if the insert is around 15 - 20% of the current size.
  • Indexes do not give back space from deleted rows
  • Primary keys are unique and cannot be null
  • Unique keys may have no duplicates, but may be null
  • Index foreign keys to prevent locking problems