Hello,
How will I be able to reduce the Spool of my query below:
LOCKING ROW FOR ACCESS
SELECT
VCCN863.ORDER_ID AS ORDER_ID,
VCCN863.EVENT_ORIGINATOR_NM AS ATTUID,
VCCN863.BAN AS BAN,
VCCN863.EXCEPTION_EVENT_TS AS BEGIN_TIME
FROM TELCO_UNREG_RETAIL_VIEWS.VCCN863_EXCEPTION_EVENT_H IST VCCN863
INNER JOIN TELCO_UNREG_RETAIL_VIEWS.VCCN863_EXCEPTION_EVENT_H IST VCCN863_END
ON VCCN863.ORDER_ID = VCCN863_END.ORDER_ID
and vccn863.EVENT_TYPE_NM = 'Item Pkg'
and vccn863_end.EVENT_TYPE_NM = 'Item Msg'
and vccn863.package_method_nm = 'Worklist Manager'
INNER JOIN TELCO_UNREG_RETAIL_VIEWS.VCCN863_EXCEPTION_EVENT_H IST VCCN863_END2
on VCCN863_END .order_id = VCCN863_end2.order_id
and VCCN863_END2.EVENT_TYPE_NM = 'Item Pkg'
and VCCN863_end2.PACKAGE_METHOD_NM = 'Assign To Me'
WHERE VCCN863.EXCEPTION_EVENT_TS between timestamp '2009-09-05 00:00:00'
and timestamp '2009-09-07 00:00:00'
GROUP BY
VCCN863.ORDER_ID,
VCCN863.EVENT_ORIGINATOR_NM ,
VCCN863.BAN ,
VCCN863.EXCEPTION_EVENT_TS ,
ORDER BY 4