Multiple choice technology databases

Which of the following utility is recommended after REORG is performed on tablespaces?

  1. Recover

  2. Repair

  3. Rebuild

  4. Runstats

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

RUNSTATS is recommended after REORG because REORG changes the physical data distribution, making existing statistics obsolete. RUNSTATS collects fresh statistics about table data distribution, enabling the optimizer to choose efficient access paths for subsequent queries.