SQL Performance (MOSC)

MOSC Banner

Sql Tuning - FTS

edited May 23, 2013 3:58AM in SQL Performance (MOSC) 26 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center