full cycle structure...command select *

• forsqlserver

  SSCoach

  Points: 18902

  More actions

  August 9, 2010 at 12:08 am

  #148430

  If I am running a command select * then what is running in backend ,full cycle structure...

  Thanks

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  August 9, 2010 at 12:38 am

  #1203996

  "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;-)