Help - Search - Members - Calendar
Full Version: COALESCE and REBUILD
Oracle DBA Forums > Oracle > Oracle Forum
karthickr
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
Oraclelearner
Hello,

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

Regards,
Oraclelearner
serenaender
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.