Post reply

Select Statement Performance

  • August 1, 2009 at 9:07 am

    #136840

    hi,

    In our project we use auto generated CRUD Stored procs for Database Tables.

    The Read proc, just selects all the columns from the table.

    But in reality, we don't require all the columns from a table.

    So is it really a performance hit when we execute the Read proc to a custom proc that just selects the columns we need.

    in a nut sheel will,

    Select Col1, Col12, Col15 FROM [Table]

    improve performance to this statement

    Select Col1, Col 2, Col 3 ......., Col 25 FROM [Table]

    if we need only col1,col12,col15 from [Table].

  • August 1, 2009 at 9:09 am

    #1033345

    Duplicate post. No replies to this thread please.

    Direct replies to http://www.sqlservercentral.com/Forums/Topic763603-338-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply