1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
set serveroutput off
SELECT /*+ gather_plan_statistics */ T0.object_id,
T0.u7e_fr_s_lastmodifier,
T0.u79_fr_s_uocode,
T0.u63_fr_s_operationid,
T0.u7b_fr_s_customername,
T0.u65_fr_n_businessid,
T0.u81_fr_s_linkedvisionreference,
T0.u70_fr_t_completiondate,
T0.u71_fr_t_donedate,
T0.doc_state
FROM (SELECT *
FROM DocVersion
WHERE (object_class_id IN (:1, :2, :3) OR object_class_id IS NULL)
AND home_id IS NULL) T0
LEFT JOIN (SELECT *
FROM Generic
WHERE (object_class_id IN (:4) OR object_class_id IS NULL)
AND home_id IS NULL) T1 ON T0.u68_refoperationproduct =
T1.object_id
LEFT JOIN (SELECT *
FROM Generic
WHERE (object_class_id IN (:5) OR object_class_id IS NULL)
AND home_id IS NULL) T2 ON T0.u65_fr_n_businessid =
T2.u4f_fr_n_businessid
WHERE (((T0.doc_state <> :6 AND T0.u65_fr_n_businessid IN (:7, :8, :9) AND
T1.u2b_fr_n_mo = :12 AND T0.u79_fr_s_uocode IN (:13, :14, :15)
)))
ORDER BY T0.u7b_fr_s_customername ASC,
T2.u50_fr_s_productgroup ASC,
T2.u51_fr_s_product ASC,
T1.object_id ASC,
T2.u52_fr_s_transaction ASC,
T0.u6a_fr_t_initiateddate DESC,
T0.object_id ASC,
T2.object_id ASC
/
select * from table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST'))
/ |
Partager