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?

Question

Accepted Answer

A. Set OPTIMIZER_USE_PENDING_STATISTICS to TRUE.

Answer

B. Set AUTO_UPDATE_STATISTICS to FALSE.

Answer

C. Use a HOLD HINT in the SQL.

Answer

D. Set AUTOMATIC_WORKLOAD_REPOSITORY_COLLECTION to PAUSE.

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…

Question

Options

How the community answered

Community Discussion