You Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster.

Why a table purged by 99% still costs a full scan exactly what it did when it was full: the high-water mark, why DELETE never lowers it, how to find bloated tables from DBA_TABLES, and how SHRINK SPACE or MOVE ONLINE fixes it — with a lab where the same scan costs 6,074 consistent gets before the delete, 6,074 after it, and 64 after the shrink.