QuestionQ64

VerifiedMonitor, configure, and optimize database resources

You have an Azure SQL database named DB1.

You need to show a query's estimated execution plan by using the query editor in the Azure portal.

What should you do first?

Explanation

Azure portal query-plan analysis depends on Query Store being enabled for the database, because Query Store captures and retains query plans. The capture policy can be adjusted after Query Store is enabled, but it is not the initial prerequisite. SET SHOWPLAN_ALL returns textual showplan output for a session, and SET FORCEPLAN changes join-processing behavior; neither enables portal plan display.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!