Hi,
My environment is Applications :12.1.3 , DB: 11.2.0.3 and OS: RHL 6.
I am issuing the select query where base table is PA_EXPENDITURE_ITEMS_ALL and it has index PA_EXPENDITURE_ITEMS_N10 (On original_transaction_reference, and transaction_source columns of table ). View QUEST_IPMS_EFFORT_MOVE_VALID_V is created on table. But select query is taking full table scan and taking too much of time, please suggest me on this.
SELECT STATEMENT ALL_ROWS Cost: 224,318 Bytes: 838 Cardinality: 2 |
- 1 TABLE ACCESS FULL TABLE PA.PA_EXPENDITURE_ITEMS_ALL Cost: 224,318 Bytes: 838 Cardinality: 2
|
-------------------------------------------------------------------------------------------------
(View code:
SELECT bill_amount,
NVL (attribute9, orig_transaction_reference)
ORIG_TRANSACTION_REFERENCE,
quantity AS hours
FROM apps.pa_expenditure_items_all
WHERE system_linkage_function = 'ST';)
--------------------------------------------------------------------------------------------------------
Main Query:
SELECT ORIG_TRANSACTION_REFERENCE,
BILL_AMOUNT
FROM IPMS.QUEST_IPMS_EFFORT_MOVE_VALID_V
WHERE (( ORIG_TRANSACTION_REFERENCE='2od0n7g0aa20015000030ag19l'
AND HOURS =5.0 )