Eliminating Mysterious Oracle Indexes

Oracle by default will create cryptic names for indexes unless you specify your own. To get a list of all the indexes currently in use for your schema you can execute: > select * from user_indexes; Anything that starts with SYS_ and ends with a $ is an autogenerated index name. It is good to ...