unable to reduce the cost of the query [message #388536] |
Wed, 25 February 2009 04:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dhanamukesh
Messages: 51 Registered: January 2009
|
Member |
|
|
SELECT a.name,
c.encryp_item_val, pkg_pci_cmmn_decrypt.fcn_get_decrypt_val_aes ('BAT', e.reference_nbr, e.order_date, 'RA') as card_nbr,e.*
FROM express_pay_order e, transaction_encryp_item c, agent a
WHERE e.reference_nbr = c.tran_ref_id
and e.rcv_agent_id = a.agent_id
The cost of the above said query would be 261753.I have tried to rearranged the where clause and then tried with index creation also.
But still, the cost is same.Please help me out to tune this query.
Here i have attached DDL of each of the tables.
Regards,
Dhanalakshmi
-
Attachment: DDL.txt
(Size: 2.17KB, Downloaded 1307 times)
|
|
|
|
|
|
|