Home Forums SQL Server 2005 T-SQL (SS2K5) How to optimize case statement RE: How to optimize case statement

  • January 22, 2014 at 12:12 am

    #1682275

    thbaig1 (1/17/2014)

    Hi,

    I have several rule on my item name to compute its gender. I know this structure might need to tune , but currently can't change:(

    I wrote sql and its working perfect. But as it has many cases and left and right functions,there are more conditions but I am posting just basic one. I would love to optimize my code.

    Why do you think it needs tuning? Have you run the query with and without the case and seen what the time difference is? If it enough of a time difference and is the overall query enough of a performance problem to warrant looking at?

    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