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

full cycle structure...command select * Expand / Collapse
Author
Message
Posted Monday, August 09, 2010 12:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 10, 2014 6:28 PM
Points: 1,199, Visits: 1,898
If I am running a command select * then what is running in backend ,full cycle structure...

Thanks

Post #965735
Posted Monday, August 09, 2010 12:38 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
"select *" command will fetch every thing from the given table.
select the "acual execution plan " option to see how sql optimizer is fetching data.means which index or which operator is being used.



-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #965740
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse