How to create explain in sql

• sudarshanpatil6060

  Newbie

  Points: 9

  More actions

  April 4, 2013 at 3:06 am

  #276083

  explain for as select statement....

  explain for select * from employees

  we also provide oracle,sql training http://oracletrainingpune.blogspot.in

• Lowell

  SSC Guru

  Points: 323527

  More actions

  April 4, 2013 at 6:11 am

  #1603508

  sudarshanpatil6060 (4/4/2013)

  ---

  explain for as select statement....

  explain for select * from employees

  we also provide oracle,sql training http://oracletrainingpune.blogspot.in

  posts like this make me want to cry.

  you offer training, but seem to be asking the most basic of questions?

  this is sort of like "What does Accounts Payable mean", and oh and by the way, we teach accounting.

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• Eric M Russell

  SSC Guru

  Points: 125596

  More actions

  April 5, 2013 at 8:22 am

  #1603928

  sudarshanpatil6060 (4/4/2013)

  ---

  explain for as select statement....

  explain for select * from employees

  we also provide oracle,sql training http://oracletrainingpune.blogspot.in

  Are you asking what the SQL Server equivalent of Oracle's EXPLAIN PLAN ?

  Perhaps this is what you're lookin for.

  SET SHOWPLAN_ALL

  http://msdn.microsoft.com/en-us/library/ms187735.aspx

  "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho