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 @ 6:41 PM
Points: 14,541, Visits: 38,384
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 2:28 PM
Points: 4,098, Visits: 9,188
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



"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Post #1439251
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse