SQL Language (MOSC)

MOSC Banner

Query Tuning

edited Mar 14, 2013 5:11AM in SQL Language (MOSC) 6 commentsAnswered
Hello,
I have attached the query that needs to be tuned. I dont have much experience with query tuning and therefore need help on the same.

Please find below the query and the attached execution plan.

SELECT FILL.COUNTRY,FILL.PIN_NUM,TO_CHAR(FILL.EFFDT,'YYYY-MM-DD'),TO_
         CHAR(FILL.EFFDT_OTH,'YYYY-MM-DD'),FILL.ABS_TYPE_OPTN,FILL.EFF_STATUS,
         FILL.DISPLAY_ORDER,FILL.RQST_ALLOWED_BY,FILL.ABS_TL_ENTRY_IND,FILL.DE
         SCR FROM PS_GP_ABS_TKTPE_VW FILL  WHERE FILL.PIN_NUM IN ( SELECT
         DISTINCT SS.PIN_TAKE_NUM FROM PS_GP_ABS_SS SS , PS_GP_ABS_TAKE TK ,

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