Tuesday, May 12, 2009

Check if index(es) used in your Query.

Open New Query and write your query. Before executing your query press CTRL + L see estimated execution for your query. You can mouse over each node in the execution plan to get more information about that step, such as the type of operation that node represents, the number of rows affected, and a breakdown of the costs associated with that step.





No comments:

Post a Comment

 
span.fullpost {display:inline;}