I have a DB2 SQL background.
Is there something similar to the "EXPLAIN" verb in Microsoft SQL Server
that will allow me to analyze a SQL statement and determine its access path,
etc., and determine how efficient the SQL is?
Let me know.
Thanks in advance.Run the query in Query Analyzer and turn on options like Show Execution
Plan, Show Server Trace, Show Client Statistics. You can also save the
query as a .sql file and give it to the database engine tuning advisor.
"wnfisba" <wnfisba@.discussions.microsoft.com> wrote in message
news:BD207A57-4F6D-4543-9691-32466B165BA1@.microsoft.com...
>I have a DB2 SQL background.
> Is there something similar to the "EXPLAIN" verb in Microsoft SQL Server
> that will allow me to analyze a SQL statement and determine its access
> path,
> etc., and determine how efficient the SQL is?
> Let me know.
> Thanks in advance.
>|||In addition to what Aaron suggests, look up SET SHOWPLAN_ALL in Books Online
.
ML
http://milambda.blogspot.com/|||Just like on DB2 too, there are sql tuning tools like SQL Optimizer for
Visual Studio. You can check it out at
http://www.extensibles.com/modules...=Products&op=NS
examnotes <wnfisba@.discussions.microsoft.com> wrote in
news:BD207A57-4F6D-4543-9691-32466B165BA1@.microsoft.com:
> I have a DB2 SQL background.
> Is there something similar to the "EXPLAIN" verb in Microsoft SQL
> Server that will allow me to analyze a SQL statement and determine its
> access path, etc., and determine how efficient the SQL is?
> Let me know.
> Thanks in advance.
>
The Relentless One
Debugging is a state of mind
http://www.extensibles.com/|||Jeez. quit spamming the boards...
Stu|||Yep, he's relentless.
Nomen est omen.
ML
http://milambda.blogspot.com/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment