Hi,
What is the difference between COALESCE and REBUILD


SQL> ALTER index IND_ACC_TR COALESCE;

Index altered.

SQL> ALTER index IND_ACC_TR rebuild;

Index altered.


Regards,
Karthick R

Hello,

I would suggest that you read this: http://www.dbspecialists.com/specialists/s...ist2006-04.html

Regards,
Oraclelearner

With COALESCE the index structure isn`t altered. The index keys in leaf blocks are spread in the leaf blocks that aren`t full and the empty leaf blocks are freed.

With REBUILD the blevel can be reduced as not only the empty leaf blocks are freed but also the branch blocks that only have one pointer.

REBUILD has more cost than COALESCE.