Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to create explain in sql Expand / Collapse
Author
Message
Posted Thursday, April 4, 2013 3:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 4, 2013 3:26 AM
Points: 1, Visits: 3
explain for as select statement....
explain for select * from employees

we also provide oracle,sql training http://oracletrainingpune.blogspot.in
Post #1438692
Posted Thursday, April 4, 2013 6:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 7:44 AM
Points: 12,910, Visits: 32,015
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1438743
Posted Friday, April 5, 2013 8:22 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 4:17 PM
Points: 1,651, Visits: 4,709
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
Post #1439251
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse