Execution time for Select query

• aniket-750033

  Mr or Mrs. 500

  Points: 599

  More actions

  November 11, 2009 at 11:20 pm

  #227887

  Can anyone please tell me whether

  select * from table where flag = True

  requires more time than selecting only few columns from the table.

  e.g.

  select pkid, Amount from table where flag = True

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  November 12, 2009 at 12:27 am

  #1078184

  See if this helps yeah! Its a pretty common question and I just did a search here on SSC and found this topic.

  http://www.sqlservercentral.com/Forums/Topic453737-338-1.aspx

  ---------------------------------------------------------------------------------

• aniket-750033

  Mr or Mrs. 500

  Points: 599

  More actions

  November 12, 2009 at 12:42 am

  #1078188

  Thanks Nabha, it really helped me.