When you want to see the method chosen by the SQL Server query optimizer to retrieve data, which option is set to enabled?

Options
- STATISTICS IO
- STATISTICS TIME
- STATISTICS PROFILE
- SHOWPLAN


CORRECT ANSWER : SHOWPLAN

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


Advertisement