[Solved] How do we make Microsoft SQL Server Management Studio behave in a More Prompt Manner?

Question

Other than the number of rows affected by a query, you can also display the the steps that your database server actually performed to execute your query. This is often called the “execution plan”. In SQL Server Management Studio, you can select the Include Actual Execution Plan (Ctrl+M) option prior to executing your query. Following execution you can view details describing how SQL Server executed your query by looking at the Execution plan tab. In Oracle, which I am less familiar with, there is a similar capability implemented by the EXPLAIN PLAN statement.

Accepted Answer

Other than the number of rows affected by a query, you can also display the the steps that your database server actually performed to execute your query. This is often called the “execution plan”. In SQL Server Management Studio, you can select the Include Actual Execution Plan (Ctrl+M) option prior to executing your query. Following execution you can view details describing how SQL Server executed your query by looking at the Execution plan tab. In Oracle, which I am less familiar with, there is a similar capability implemented by the EXPLAIN PLAN statement.