Which would you configure for that to occur?

Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database.
Which would you configure for that to occur?

Instead of a database automatically publishing statistics when statistics collection ends, you want to test queries a satisfactory result before they are made available to the entire database.
Which would you configure for that to occur?

A.
SetOPTIMIZER_USE_PENDING_STATISTICStoTRUE.

B.
SetAUTO_UPDATE_STATISTICStoFALSE.

C.
Use aHOLD HINTin the SQL.

D.
SetAUTOMATIC_WORKLOAD_REPOSITORY_COLLECTIONtoPAUSE.



Leave a Reply 1

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