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

Options
- IntelliSense of SQL Server 2008 is ON by default
- DML statements can also be used with IntelliSense
- IntelliSense of SQL Server 2008 is OFF by default
- Both a and b above

CORRECT ANSWER : Both a and b above

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. IntelliSense of SQL Server 2008 is ON by default. DML statements can also be used with IntelliSense.

Prajakta Pandit 03-8-2017 12:16 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
 
▲