The SELECT A.O RDER_ITEM_ID, a. d. P_ORDER_ID, A.O FFER_INST_ID, A.O FFER_ID, A.O FFER_PKG_ID, A.O PERATION_TYPE
The FROM DP_OFFER_ORDER A, ORDER_ITEM B, OFFER C
WHERE C.O FFER_ID=A.O FFER_ID
AND A.O RDER_ITEM_ID=B.O RDER_ITEM_ID

AND B.O RDER_STATE NOT IN (' E ', 'C', 'M')

The execution plan

CodePudding user response:

This is the cartesian product,
Statistical information collected under the first