Sql Tuning - FTS
Hi Gurus,
Could someone help me tune this sql. I want to avoid the FTS on OVP_CREATE_SESSION table and reduce the cost. I have tried creating index on client_awaiting_approval and transaction_status, but optimizer is always choosing to do FTS on OVP_CREATE_SESSION table.
SELECT ocs.session_id, to_char(ocs.update_date,'yyyy/mm/ddHH24:MI') as update_date, ocs.transaction_status, ocs.country_code, ocs.transaction_id, ocs.contact, ocs.address FROM
ovp_create_session ocs WHERE ocs.client_awaiting_approval ='Y' OR ocs.transaction_status NOT IN ('COMPLETE', 'REJECTED') ORDER BY ocs.update_date ASC
Could someone help me tune this sql. I want to avoid the FTS on OVP_CREATE_SESSION table and reduce the cost. I have tried creating index on client_awaiting_approval and transaction_status, but optimizer is always choosing to do FTS on OVP_CREATE_SESSION table.
SELECT ocs.session_id, to_char(ocs.update_date,'yyyy/mm/ddHH24:MI') as update_date, ocs.transaction_status, ocs.country_code, ocs.transaction_id, ocs.contact, ocs.address FROM
ovp_create_session ocs WHERE ocs.client_awaiting_approval ='Y' OR ocs.transaction_status NOT IN ('COMPLETE', 'REJECTED') ORDER BY ocs.update_date ASC
0