Efficency

From: Steven R Fuller <srfuller_at_doitnow.com>
Date: Fri, 17 Sep 1999 21:35:43 -0700
Message-ID: <37E3169E.E756C309_at_doitnow.com>



Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

[Quoted] Can Anyone give me some feedback as to how I can make this run a little faster

SELECT

         A.Loc_Date

,C.Location_Name
,B.Team_Name
,CONCAT(B.Lname,CONCAT(', ',B.Fname))
,A.Excode
,TO_CHAR(A.Beg_Time,'HH24:MI')
,DECODE(SIGN(A.End_Time -
A.Beg_Time),-1,'23:59',TO_CHAR(A.End_Time,'HH24:MI'))
,E.Hlfhr
,Count(DISTINCT A.Excode)
,Decode(Sum(C.Calls_Handled),0,'<4'

,decode(Sign((Sum(C.Calls_Handled_In_Service)/Sum(C.Calls_Handled))-0.39),-1,'<4'

,decode(Sign((Sum(C.Calls_Handled_In_Service)/Sum(C.Calls_Handled))-0.59),-1,'<6'

,decode(Sign((Sum(C.Calls_Handled_In_Service)/Sum(C.Calls_Handled))-0.79),-1,'<8'

,decode(Sign((Sum(C.Calls_Handled_In_Service)/Sum(C.Calls_Handled))-1.0),-1,'<10',0))))) SLDECODE

FROM     Traffic.Segment_Half_Hour                        C
                ,Traffic.agent_performance                         B
               ,Traffic.TCS_Exception_Count                   A

,Traffic.Halfhr                                             E
               ,Traffic.REL_TCS_Exception_Codes         F

WHERE   A.Node          =       B.Node
  AND   A.Loc_Date      =       B.Date_Stamp
  AND   A.Epid          =       RTRIM(B.Unum)
  AND   A.Node          =       C.Node
  AND   A.Loc_Date      =       C.Date_Stamp
  AND   A.Excode        =       F.Exception_Code

  AND E.Hlfhr >= ((TO_CHAR(A.Beg_Time,'HH24')*2) + DECODE(SIGN(TO_CHAR(A.Beg_Time,'MI')-29),-1,0,0,1,1,1)) + 1   AND E.Hlfhr < DECODE(SIGN(A.End_Time - A.Beg_Time),-1,48,((TO_CHAR(A.End_Time,'HH24')*2) + DECODE(SIGN(TO_CHAR(A.End_Time,'MI')-29),-1,0,0,1,1,1)) + 1)   AND E.Hlfhr = C.HalfHour_Sort

  AND A.Loc_Date BETWEEN TO_DATE('9/13/99','mm/dd/yy') AND TO_DATE('9/13/99','mm/dd/yy')
  AND NOT F.Exception_Group IN ('OVTM','PAID','UNPD')   AND B.Team_Name LIKE 'NIS%'

        GROUP BY         A.Loc_Date
                        ,C.Location_Name
                        ,B.Team_Name
                        ,CONCAT(B.Lname,CONCAT(', ',B.Fname))
                        ,A.Excode
                        ,TO_CHAR(A.Beg_Time,'HH24:MI')
                        ,DECODE(SIGN(A.End_Time -
A.Beg_Time),-1,'23:59',TO_CHAR(A.End_Time,'HH24:MI'))
                        ,E.Hlfhr



--------------E796CD8AD939726B5CFC6D5C
Content-Type: text/x-vcard; charset=us-ascii;  name="srfuller.vcf"

Content-Transfer-Encoding: 7bit
Content-Description: Card for Steven R Fuller
Content-Disposition: attachment;

 filename="srfuller.vcf"

begin:vcard
n:;srfuller_at_doitnow.com
x-mozilla-html:FALSE
version:2.1
email;internet:srfuller_at_doitnow.com
x-mozilla-cpt:;0
fn:srfuller_at_doitnow.com
end:vcard

--------------E796CD8AD939726B5CFC6D5C-- Received on Sat Sep 18 1999 - 06:35:43 CEST

Original text of this message