Database Tuning (MOSC)

MOSC Banner

Query tuning

edited Apr 6, 2010 9:04PM in Database Tuning (MOSC) 11 commentsAnswered
Hi Gurus,

I am relatively new to tuning, i ha ve a sql query running in the database which along with its execution plan is as follows

SELECT   addss.line1 addss_line1,   addss.pcode addss_pcode,   addss.suburb
addss_suburb,   addss.state_code addss_state_code,
NVL(roles.end_dttm,TO_DATE('31/12/2099', 'DD/MM/YYYY')) roles_end_dttm,
roles.start_dttm roles_start_dttm,   roles.patnt_refno refno,   roles.patnt_refno
perca_patient_refno,   roles.emplr_refno emplr_refno,   roles.secure_flag
roles_secure_flag  FROM address_roles roles,   addresses addss  WHERE
addss.addss_refno = roles.addss_refno  AND roles.rotyp_code = :1  AND

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