DBMS_XPLAN.DISPLAY not showing the given recommended hint
Hi,
i got an questions on the DBMS_XPLAN.DISPLAY.
by right, when we explain plan for a sql statment. by running below sql.
SELECT * FROM table (DBMS_XPLAN.DISPLAY);
it should be showing the execution plan for that sql that i had explained.
last 2 weeks ago, i had tune a sql and had added hint to the sql to use index when executing it. it produce a report as what expected.
SQL
SELECT DECODE (SUM (CHARGEABLE), NULL, 0, SUM (CHARGEABLE))
FROM ORDER_DETAIL, (SELECT DISTINCT FACILITY, ORDER_NUM, PRODUCT_FLAG FROM INV WHERE
FACILITY = :B3 AND INVOICE_NUMBER = :B2 AND NAME = :B1 ) B
i got an questions on the DBMS_XPLAN.DISPLAY.
by right, when we explain plan for a sql statment. by running below sql.
SELECT * FROM table (DBMS_XPLAN.DISPLAY);
it should be showing the execution plan for that sql that i had explained.
last 2 weeks ago, i had tune a sql and had added hint to the sql to use index when executing it. it produce a report as what expected.
SQL
SELECT DECODE (SUM (CHARGEABLE), NULL, 0, SUM (CHARGEABLE))
FROM ORDER_DETAIL, (SELECT DISTINCT FACILITY, ORDER_NUM, PRODUCT_FLAG FROM INV WHERE
FACILITY = :B3 AND INVOICE_NUMBER = :B2 AND NAME = :B1 ) B
0