How to create explain in sql

  • explain for as select statement....

    explain for select * from employees

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

  • sudarshanpatil6060 (4/4/2013)


    explain for as select statement....

    explain for select * from employees

    we also provide oracle,sql training http://oracletrainingpune.blogspot.in[/quote%5D

    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!

  • sudarshanpatil6060 (4/4/2013)


    explain for as select statement....

    explain for select * from employees

    we also provide oracle,sql training http://oracletrainingpune.blogspot.in[/quote%5D

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply