Oracle Community Network
what are main 3 purposes to rebuild an index?
1.increase searching speed
2.increase searching speed
3.increase searching speed
Thanks very much.
Can u give me your gmail id, so that we can share more ?
The purpose to rebuild an index is:
a) When large datasets are added and removed, the need to rebuild indexes is common.
b) In system that never update or delete rows, index rebuilding rarely improve performance
c) In systems that do batch DML jobs, index rebuilding often improves SQL performance.
we rebuild an index if the
INDEX height >3 and
deleted leaf rows are greater than >20%
we see this from
sql> select height,if_rows,del_if_rows from index_stats;