■

sqlplus test/test@xxxx

set line 120

SET AUTOTRACE TRACEONLY

alter session set use_stored_outlines =OLTP;
SELECT
ORDERS.ORDER_NO,
ORDERS.TOTAL_AMOUNT,
ORDERS.DELIVERY_CHARGES,
ORDERS.TAX,
ORDERS.ORDER_DATE,
CUSTOMER.CUSTOMER_NAME,
PRODUCT.PRODUCT_NAME,
PRODUCT.PRICE,
ORDER_DETAIL.QUANTITY
FROM ORDERS
JOIN CUSTOMER ON CUSTOMER.CUSTOMER_CODE = ORDERS.CUSTOMER_CODE
JOIN ORDER_DETAIL ON ORDER_DETAIL.ORDER_NO = ORDERS.ORDER_NO
JOIN PRODUCT ON PRODUCT.PRODUCT_CODE = ORDER_DETAIL.PRODUCT_CODE
WHERE CUSTOMER.CUSTOMER_CODE ='xxxx';

alter session set use_stored_outlines =false;
SELECT
ORDERS.ORDER_NO,
ORDERS.TOTAL_AMOUNT,
ORDERS.DELIVERY_CHARGES,
ORDERS.TAX,
ORDERS.ORDER_DATE,
CUSTOMER.CUSTOMER_NAME,
PRODUCT.PRODUCT_NAME,
PRODUCT.PRICE,
ORDER_DETAIL.QUANTITY
FROM ORDERS
JOIN CUSTOMER ON CUSTOMER.CUSTOMER_CODE = ORDERS.CUSTOMER_CODE
JOIN ORDER_DETAIL ON ORDER_DETAIL.ORDER_NO = ORDERS.ORDER_NO
JOIN PRODUCT ON PRODUCT.PRODUCT_CODE = ORDER_DETAIL.PRODUCT_CODE
WHERE CUSTOMER.CUSTOMER_CODE ='XXXX';