Question: A DBA has run RUNSTATS for table space DB 1 . TS 1 multiple times with different RUNSTATS options. As a result, some of the
A DBA has run RUNSTATS for table space DBTS multiple times with different RUNSTATS options. As a result, some of the statistics are outdated.
How can the DBA clean up these obsolete statistics?
Question Select one:
A
The DBA cannot explicitly remove the old statistics from the catalog; however, the next time a REORG is run, Db will clean them up and generate new values as requested via the utility control statement
B
The only way to remove obsolete statistics from the catalog is to use SQL DML to manually update the catalog
C
The DBA does not have to do anything special, because the RUNSTATS utility always cleans up all statistics information in the catalog before it generates and writes new statistics
D
The DBA can use the RUNSTATS utility with the RESET ACCESSPATH option.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
