Index Coalesce

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 …