Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started