• 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