Compound Index on a DFF field + standard field on apps base tables
Dear Experts,
One of my queries on Projects table is running extremely slow and the reason I found is that in the query there is a business reason for using NVL(attribute9, original_transaction_reference) in the where clause. Though Original_transaction_reference is already indexed by Oracle, because attribute9 is not being indexed the query is not running optimally.
Query:
select * from apps.pa_expenditure_items_all where nvl(attribute9, orig_transaction_reference)='2od0n7g0aa20015000030ag19l';
Explain Plan
Plan SELECT STATEMENT ALL_ROWS Cost: 224,397 Bytes: 42,440,929 Cardinality: 101,291 1 TABLE ACCESS FULL TABLE PA.PA_EXPENDITURE_ITEMS_ALL Cost: 224,397 Bytes: 42,440,929 Cardinality: 101,291
0