explain plan for
SELECT MMT.TRANSACTION_ID,GIR.JE_HEADER_ID,GIR.JE_LINE_NUMFROM GL_IMPORT_REFERENCES GIR ,MTL_MATERIAL_TRANSACTIONS MMTWHERE 1=1AND GIR.JE_HEADER_ID = :1AND GIR.JE_LINE_NUM = :2;select *from table(dbms_xplan.display) xplan;select * from plan_table;