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)
Hi,
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;
Index analyzed
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 rohitsn@altavista.com
Reply With Quote
Bookmarks