Index Coalesce
Oracle Index Rebuild and Coalesce with ALTER INDEX
Jun 6, 2026 / · 6 min read · ALTER INDEX Index Rebuild Index Coalesce Index Maintenance Oracle Structure Oracle DBA Scripts ·Oracle Index Rebuild and Coalesce with ALTER INDEX Purpose Over months of heavy delete and update activity, a B-tree index can accumulate empty and half-full leaf blocks. The index keeps working, but it grows wider than the data it points to, so range scans read more blocks than they need and the segment holds space …
Read More