SQLServerCentral / Administering / SQL Server 2005 / full cycle structure...command select * / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 09:25:33 GMT20RE: full cycle structure...command select *http://www.sqlservercentral.com/Forums/Topic965735-146-1.aspx"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. Mon, 09 Aug 2010 00:38:33 GMTBhuvneshfull cycle structure...command select *http://www.sqlservercentral.com/Forums/Topic965735-146-1.aspxIf I am running a command select * then what is running in backend ,full cycle structure...Mon, 09 Aug 2010 00:08:14 GMTforsqlserver