Local Variable & Performance

  • Experts,

    while tuning the stored procedure ,I have found there were more than 500 local variables used in that procedure. Will it affect the performance ?

    karthik

  • The existence of the variables shouldn't affect the performance directly. Assuming, of course, that they are actually needed for the proc.

    How they are used can very definitely affect performance.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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