<SQL_EXPLAIN_PLAN>
<DATA_DS>
<![CDATA[
Datamodel SQL Explain Plan Report
================================================================
Driver Details:JDBC Driver:Oracle JDBC
driver:weblogic.jdbc.wrapper.PoolConnection_oracle_jdbc_driver_T4CConnection:19.23.
0.0.0
DBName:Oracle
DBVersion:Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.26.0.0.0
SQLQuery:EXPLAIN PLAN SET STATEMENT_ID = 'dm_plan_Q_250508_093348' FOR
SELECT
egp.item_number AS Item_Number,
egp.inventory_item_id AS Item_ID,
dfl.fulfill_line_id AS Fulfill_Line_ID,
dfl.ordered_qty AS Ordered_Quantity,
dfl.fulfillment_date AS Fulfillment_Date,
wdd.delivery_detail_id AS Delivery_ID,
wdd.source_shipment_number AS Shipment_Number,
wdd.shipped_quantity AS Shipped_Quantity,
wdd.transaction_id AS Transaction_ID
FROM
EGP_SYSTEM_ITEMS_B egp
JOIN
DOO_FULFILL_LINES_ALL dfl ON egp.inventory_item_id = dfl.inventory_item_id
JOIN
WSH_DELIVERY_DETAILS wdd ON egp.inventory_item_id = wdd.inventory_item_id
WHERE
egp.item_number IN ('8802', '23004')
AND dfl.fulfillment_date >= nvl(null,dfl.fulfillment_date)
AND dfl.fulfillment_date < nvl(null,dfl.fulfillment_date)
ORDER BY
dfl.fulfillment_date DESC
SQL Query Timeout: 600
Number of SQL Executions: 1
PLAN_TABLE_OUTPUT
-----------------------------------------------------------------------------------
------------------
Plan hash value: 2984560806
-----------------------------------------------------------------------------------
--------------------------------------------
| Id | Operation | Name |
Rows | Bytes |TempSpc| Cost (%CPU)| Time |
-----------------------------------------------------------------------------------
--------------------------------------------
| 0 | SELECT STATEMENT | |
26M| 1977M| | 463K (1)| 00:00:19 |
| 1 | SORT ORDER BY | |
26M| 1977M| 2359M| 463K (1)| 00:00:19 |
|* 2 | HASH JOIN | |
26M| 1977M| | 33513 (1)| 00:00:02 |
| 3 | JOIN FILTER CREATE | :BF0000 |
18784 | 917K| | 8125 (1)| 00:00:01 |
| 4 | NESTED LOOPS | |
18784 | 917K| | 8125 (1)| 00:00:01 |
| 5 | NESTED LOOPS | |
286K| 917K| | 8125 (1)| 00:00:01 |
| 6 | INLIST ITERATOR | |
| | | | |
| 7 | TABLE ACCESS BY INDEX ROWID BATCHED| egp_system_items_b |
42 | 840 | | 19 (0)| 00:00:01 |
|* 8 | INDEX RANGE SCAN | EGP_SYSTEM_ITEMS_B_N1 |
42 | | | 4 (0)| 00:00:01 |
|* 9 | INDEX RANGE SCAN | DOO_FULFILL_LINES_ALL_FK4 |
6816 | | | 43 (0)| 00:00:01 |
|* 10 | TABLE ACCESS BY INDEX ROWID | doo_fulfill_lines_all |
444 | 13320 | | 6342 (1)| 00:00:01 |
| 11 | JOIN FILTER USE | :BF0000 |
850K| 22M| | 25336 (1)| 00:00:01 |
|* 12 | TABLE ACCESS STORAGE FULL | wsh_delivery_details |
850K| 22M| | 25336 (1)| 00:00:01 |
-----------------------------------------------------------------------------------
--------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("EGP"."INVENTORY_ITEM_ID"="WDD"."INVENTORY_ITEM_ID")
8 - access("EGP"."ITEM_NUMBER"='23004' OR "EGP"."ITEM_NUMBER"='8802')
9 - access("EGP"."INVENTORY_ITEM_ID"="DFL"."INVENTORY_ITEM_ID")
10 - filter("DFL"."FULFILLMENT_DATE">="DFL"."FULFILLMENT_DATE" AND
"DFL"."FULFILLMENT_DATE"<"DFL"."FULFILLMENT_DATE")
12 - storage(SYS_OP_BLOOM_FILTER(:BF0000,"WDD"."INVENTORY_ITEM_ID"))
filter(SYS_OP_BLOOM_FILTER(:BF0000,"WDD"."INVENTORY_ITEM_ID"))
Note
-----
- this is an adaptive plan
]]>
</DATA_DS>
</SQL_EXPLAIN_PLAN>
