Case Statement Doubles time to render results

Question

I added a case statement to a view using CTE's
After the case statement my transaction time went from 3:17 seconds to 5:54

Is there a way to diagnose and rewrite this more efficiently?

    (CASE WHEN cdp1.PRC = 0 and cdp1.PRC_TYP_ID = 41 Then ssf.PRC Else cdp1.PRC END)+
    (CASE WHEN cdp1.PRC = 0 and cdp1.PRC_TYP_ID = 43 Then ssf.PRC Else cdp1.PRC END)+
    (CASE WHEN cdp1.PRC = 0 and cdp1.PRC_TYP_ID = 124 Then ssf.PRC Else cdp1.PRC END)
    AS PRC

Answer 1

0

In order to troubleshoot what is occuring, you should post the execution plan of the query. Preference would be for the actual plan, but even the estimated plan would be useful. Just looking at this statement completely divorced from the rest of the query, it's just not possible to tell you why it's running slow.

answered Dec 28 '10 at 10:30 AM

Grant Fritchey ♦♦
61.5k ● 12 ● 19 ● 66

(comments are locked)

Case Statement Doubles time to render results

Follow this question

Related Questions