what are main 3 purposes to rebuild an index?

advance thanks

Views: 26

Replies to This Discussion

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 ?

advance thanks


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;


© 2019   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service