Replies to This Discussion

Permalink Reply by Pedro Culwell on June 19, 2013 at 1:13pm

1.increase searching speed
2.increase searching speed
3.increase searching speed

Permalink Reply by Jammie Melia on June 19, 2013 at 1:14pm

hi

Thanks very much.

Can u give me your gmail id, so that we can share more ?

advance thanks

Permalink Reply by Dane Sircy on June 19, 2013 at 1:15pm

HI ALL,

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.

Permalink Reply by Odis Stearn on June 19, 2013 at 1:16pm

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;