PrepAway - Latest Free Exam Questions & Answers

Which statement describes a way to minimize the impact …

Which statement describes a way to minimize the impact of a RUNSTATS operation?

PrepAway - Latest Free Exam Questions & Answers

A.
Reduce I/O by using a shadow table space for statistics collection.

B.
Execute the RUNSTATS command with the WITH DISTRIBUTION option specified.

C.
Execute the RUNSTATS command with the DETAILED UNSAMPLED option specified.

D.
Limit the number of pages and rows processed by using page-level or row-level table sampling.


Leave a Reply