Efficency
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