You are administering a database that supports an OLTP workload. Users complain about
the degraded response time of a query. You want to gather new statistics for objects
accessed by the query and test query performance with the new statistics without affecting
other sessions connected to the instance.
TheSTALE_PERCENTstatistic preference is set to a default value and
theSTATISTICS_LEVELparameter is set toTYPICAL.
Which two actions would you take to accomplish the task?(Choose two.)
A.
Set theSTALE_PERCENTstatistic preference to a higher value than the default, and then
gather statistics.
B.
Set theSTATISTICS_LEVELparameter toALLfor the instance.
C.
Set theINCREMENTALpreference toTRUE, and then gather statistics.
D.
Set theOPTIMIZER_USE_PENDING_STATISTICSparameter toTRUEfor the session in
which you want to test the query.
E.
Set thePUBLISHstatistic preference toFALSE, and then gather statistics.
F.
Set theNO_INVALIDATEstatistic preference toTRUE, and then gather statistics.
D,E
D, E
D, E