Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Today @ 2:03 PM
Points: 13,973, Visits: 36,283
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!
Post #1438743
Posted Friday, April 5, 2013 8:22 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:19 PM
Points: 3,198, Visits: 7,502
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



"If you break a few eggs, then make an omelet."
Post #1439251
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse