Which two actions would you take to accomplish the task?

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.)

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *