However if you want to see the execution plans using T-SQL, here's how to do so:
SET SHOWPLAN_ALL ON/OFF returns an estimated execution plan with detailed information about how the statements will be executed, without
executing the query
Similarly you can also use SET SHOWPLAN_TEXT ON which returns a textual estimated execution plan without running the query or SET SHOWPLAN_XML ON which returns an XML-based estimated execution plan without running the query.
SET STATISTICS PROFILE ON/OFF returns a detailed actual execution plan for a each query, after running the query.
Similarly you can also use SET STATISTICS IO ON to get information about IO/Disk Activity while executing the statements and SET STATISTICS TIME ON to display the milliseconds required to parse and compile each statement while executing it
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|