Home Forums SQL Server 2008 T-SQL (SS2K8) Understanding CASE processing RE: Understanding CASE processing

  • May 6, 2013 at 6:58 am

    #1612614

    Hi,

    Thanks for the explaination.

    So I don't need to worry about a big performance hit?

    Just need to remove the extra WHEN THEN ELSEs when tuning so that the results are more acurate?

    At the moment the plan is telling me that this part of the SP takes up 70% and each index seek in it takes 10%. When in reality the 70% should be considered much lower.


    For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

    "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort