Find unnecessary duplicate indexes on a table

This script will generate a drop index script which can be used to drop redundant indexes on all tables except those owned by user SYS and SYSTEM. For example, if table PERSON has two indexes -- the first one is person_id,ssn and the second one is person_id -- this script will identify the second one as dupl

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle Database Administrator Understanding SQL string functions What is the difference between a database engineer, architect and administrator? Import on one table from dump file Error during RMAN backup Can I drop a column in SYS schema? STATSPACK tool: transaction vs. execution measurement Should I port from Microsoft Access? How can I find statistics on total memory usage and database connections? Installing multiple Oracle homes Modifying SYS password in a RAC environment

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

icate index. This was tested on 8.1.7 and 9.2 versions.

Reader Feedback

Micha T. writes: About this tip, be careful when your application is still running under RBO because there your single-column indexes could be vital for index joins.

For More Information