You are a performance-sensitive DBA, and you are nervous about gathering new statistics, since
they may alter optimization plans in an unexpected way. To avoid this potential outcome, your best
course of action would be to:
A.
refrain from collecting statistics
B.
use Real Application Testing to capture the workload and the worked and then run the worked
on a test machine
C.
use hints to create fixed plans for SQL statements
D.
use deferred publishing of statistics to allow you to test execution plans before making the
statistics public
E.
use invisible indexes to dominate execution plans
Explanation: