Multiple choice technology databases

When will you chose to run RUNSTATS?

  1. After a load

  2. After mass updates

  3. After a deletes

  4. After a inserts

Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

RUNSTATS (or RUN STATISTICS) should be executed after any operation that significantly changes data distribution. This includes bulk loads, mass updates, large delete operations, and major batch inserts. Updated statistics help the query optimizer choose efficient execution plans.