You are administering a database supporting a DDS workload in which some tables are updated frequently but not queried often. You have SQL plan baseline for these tables and you do not want the automatic maintenance task to gather statistics for these tables regularly.
Which task would you perform to achieve this?
A. Set the INCREMENTAL statistic preference FALSE for these tables.
B. Set the STALE_PERCENT static preference to a higher value for these tables.
C. Set the GRANULARITY statistic preference to AUTO for these tables.
D. Set the PUBLISH statistic preference to TRUE for these tables.
|
Download Printable PDF. VALID exam to help you PASS. |
 |