How to see if my index are fragmented? If I want to rebuild index, anything I should be aware of? (performace would be bad, so I won't run rebuild script during peak time)
oralce 18.104.22.168.1 on NT4.0
Index size about 15G
use rebuild online option
If u want to see if ur indexes are fragmented ,please run the following command and view the INDEX_STATS table to get the statistics in the same session.
sql>analyze index validate structure;
sql>select name,(del_lf_rows/lf_rows)*100 "Percentage" from index_stats
If the percentage is equal or greater than 20% rebuild the index.Also rebuild the index at off-peak hours usually in the night.
In case of any help please be free to ask me at firstname.lastname@example.org
Rohit Nirkhe,Oracle DBA,OCP 8i
Click Here to Expand Forum to Full Width