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 9, 2010 12:08 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:26 AM
Points: 1,202, Visits: 1,939
If I am running a command select * then what is running in backend ,full cycle structure...

Thanks

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


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:01 AM
Points: 2,840, Visits: 3,968
"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