You want to reduce fragmentation and reclaim unused space of the SALES table but not its dependent objects. During the operation, you want to ensure the following:

DEALLOCATE UNUSED releases space above the high water mark but does not compact fragmented rows or reclaim space scattered within the allocated segment extents.

SHRINK SPACE CASCADE compacts the table and then propagates the shrink operation to all dependent objects including indexes, which violates the requirement to leave dependent objects untouched.

SHRINK SPACE COMPACT performs only the compaction phase of the shrink operation - relocating rows to reduce fragmentation - without cascading to dependent objects such as indexes. It uses short-duration row-level locks rather than a full table lock, so long-running queries against the table continue uninterrupted.

ROW STORE COMPRESS BASIC applies table compression to reduce storage for future bulk inserts, but does not address fragmentation or reclaim currently unused space within the segment.