Identifying indexes to rebuild

[castlerock]

Hi,
How to identify which indexes need to be rebuild??


Many Thanks,

[fraze]

Theres no hard and fast rule to rebuilding indexes - why do you want to rebuild them? Go to

http://asktom.oracle.com

and do a search on index rebuilds - theres loads of good stuff written by Tom on the subject

[robertbalmer]

Does your local library in town rebuild there indexes regularly...I dont think so.

Rather add indexing than rebuild on your tables.

...and follow the advice of Fraze to goto Tom

[marist89]

Hi,
How to identify which indexes need to be rebuild??


Many Thanks,

It's a simple query:

SELECT index_name FROM user_indexes
MINUS
SELECT index_name FROM user_indexes