All geek questions in one place

MS SQL Server equivalent to PostgreSQL EXPLAIN

Is there an SQL Server equivalent for the PostgreSQL EXPLAIN command that I can run on SQL Server 2008 R2 Express (i.e. without SQL Profiler)?

+6
source share
1 answer

You must use SET SHOWPLAN_ALL ON before sending a request to display the execution plan. Please note, however, that it is planned to be removed in favor of SHOWPLAN_XML in a future version.

+5
source

Source: https://habr.com/ru/post/944170/

More articles:


All Articles