Groups > comp.databases.ms-sqlserver > #1311

Re: explain? Execution plans?

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: explain? Execution plans?
Date	2012-09-20 23:36 +0200
Organization	Erland Sommarskog
Message-ID	<XnsA0D4F0382B318Yazorman@127.0.0.1> (permalink)
References	<c42ab89c-f4c1-4d85-aa89-c061471436a0@googlegroups.com>

Show all headers | View raw

björn lundin (b.f.lundin@gmail.com) writes:
> In others databases, I can run
> explain (some query)
> and get a execution plan.
> 
> We have a tool that parses source code for
> sql statements and runs explain on them.
> By doing this, we get
> * the execution plan (obviously)
> * but also a receipt that the embedded sqls are valid.
 
Any of

SET SHOWPLAN_TEXT ON
SET SHOWPLAN_ALL ON
SET SHOWPLAN_XML ON

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

explain? Execution plans? björn lundin <b.f.lundin@gmail.com> - 2012-09-20 02:05 -0700
  Re: explain? Execution plans? Erland Sommarskog <esquel@sommarskog.se> - 2012-09-20 23:36 +0200
    Re: explain? Execution plans? björn lundin <b.f.lundin@gmail.com> - 2012-09-21 01:12 -0700

csiph-web