Which of the following statements is/are false for Plan freezing?

Options
- allows the DBAs to persist plan guides which helps when a query fails
- helps to monitor schemas
- monitoring features for checking when the query is succeeded or failed
- Both a and b above

CORRECT ANSWER : helps to monitor schemas

Discussion Board
Plan freezing

Plan freezing refers to forcing a plan for a specific query. There are different reasons to freeze a plan, one is to provide plan stability for solving parameter sniffing issues. It allows the DBAs to persist plan guides which helps when a query fails. It monitors the features for checking when the query is succeeded or failed.

Prajakta Pandit 03-8-2017 12:08 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲