You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects.
During this operation, you want to ensure the following:
– Long-running queries are not affected.
– No extra space is used.
– Data manipulation language (DML) operations on the table succeed at all times throughout the process.
– Unused space is reclaimed both above and below the high water mark.Which ALTER TABLE option would you recommend?
SHRINK SPACE CASCADE
SHRINK SPACE COMPACT
ROW STORE COMPRESS BASIC