SQL Server equivalent to MySQL’s EXPLAIN

by

The MySql EXPLAIN statement can be used either as a synonym for DESCRIBE or as a way to obtain information about how MySQL executes a SELECT statement.

The closest equivalent statement for SQL Server is:

SET SHOWPLAN_ALL (Transact-SQL)
or
SET SHOWPLAN_XML (Transact-SQL)

From a SQL Server Management Studio query window, you could run SET SHOWPLAN_ALL ON or SET SHOWPLAN_XML ON and then your query. At that point It will not return the result set of the query, but the actual execution plan. When you then run SET SHOWPLAN_ALL OFF or SET SHOWPLAN_XML OFF and then run your query, you will then again get a result set.

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. How can I get column names from a table in SQL Server?
  3. How can I select the first day of a month in SQL?
  4. Multi-statement Table Valued Function vs Inline Table Valued Function
  5. SQL Server Insert if not exists
  6. Select statement to find duplicates on certain fields
  7. How to set table name in dynamic SQL query?
  8. Using a Variable in OPENROWSET Query
  9. How to find current transaction level?
  10. How do I see active SQL Server connections?
  11. Check for file exists or not in sql server?
  12. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  13. How to cast variables in T-SQL for bulk insert?
  14. How to create a PivotTable in Transact/SQL?
  15. Group DateTime into 5,15,30 and 60 minute intervals
  16. concatenate two database columns into one resultset column
  17. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  18. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  19. T-SQL and the WHERE LIKE %Parameter% clause
  20. Custom aggregate function (concat) in SQL Server
  21. Which SQL query is faster? Filter on Join criteria or Where clause?
  22. UPDATE and REPLACE part of a string
  23. Generate random int value from 3 to 6
  24. Improve SQL Server query performance on large tables
  25. The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range?
  26. Average of multiple columns
  27. Show all rows that have certain columns duplicated
  28. Select SQL Server database size
  29. Check if a parameter is null or empty in a stored procedure
  30. Cannot Resolve Collation Conflict

Leave a Comment