rebuild index

[elintrend]

Hi all,

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 8.0.5.2.1 on NT4.0
Index size about 15G

Thank you

[vutukurinr]

hi,
use rebuild online option

[rohitsn]

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

Regards.
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com