Viewing Query Plan from Activity Monitor

There are lot of options to view query plan. Activity Monitor has an option of displaying Recent Expensive Queries.

image

You can view the query plan by right clicking the relevant query by as shown below.

image

Comments

Popular posts from this blog

GROUP_CONCAT or LISTAGG

An Error Occurred during decryption when creating a linked server.

Cannot show the editor for this task.