Huge query tuning
Hi,
we need tuning this huge query, we try to attach the explain plan.
Is it possible to recognize any problem from the explain plan? I mean the cost is
low (about 200) but if we run the query it hangs, data return (about 15000 records) in more than 5 hours!
STL_AM, 31.482.990 records, 75 partitions, in a partition 433000 records on average.
STL_DMZ_AEEG, 2557 records
SCR_V_EVA_STL_TESTAT_MISURE_AM, view:
EVA_STL_TESTATA_MISURE_AM, 22327 records
STL_AM
Regards,
dario
Query :
----------------------------------------------------------------------------------------------------------
(select sys_guid(), '00', sysdate
, 'err' || u.RAG_SOC || ' - ' || a.Cod_Ruc || ' - ' || to_char(a.dta_rif,'dd/mm/yyyy hh24:mi:ss') || ' - ' || b.fascia || ' - ' || trunc(a.Val_Ene,2)
Is it possible to recognize any problem from the explain plan? I mean the cost is
low (about 200) but if we run the query it hangs, data return (about 15000 records) in more than 5 hours!
STL_AM, 31.482.990 records, 75 partitions, in a partition 433000 records on average.
STL_DMZ_AEEG, 2557 records
SCR_V_EVA_STL_TESTAT_MISURE_AM, view:
EVA_STL_TESTATA_MISURE_AM, 22327 records
STL_AM
Regards,
dario
Query :
----------------------------------------------------------------------------------------------------------
(select sys_guid(), '00', sysdate
, 'err' || u.RAG_SOC || ' - ' || a.Cod_Ruc || ' - ' || to_char(a.dta_rif,'dd/mm/yyyy hh24:mi:ss') || ' - ' || b.fascia || ' - ' || trunc(a.Val_Ene,2)
0