Query Tuning
Hello,
SELECT FILL.COUNTRY,FILL.PIN_NUM,TO_C HAR(FILL.EFFDT,'YYYY-MM-DD'),T O_
CHAR(FILL.EFFDT_OTH,'YYYY-MM- DD'),FILL.ABS_TYPE_OPTN,FILL.E FF_STATUS,
FILL.DISPLAY_ORDER,FILL.RQST_ ALLOWED_BY,FILL.ABS_TL_ENTRY_I ND,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 ,
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.
CHAR(FILL.EFFDT_OTH,'YYYY-MM-
FILL.DISPLAY_ORDER,FILL.RQST_
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 ,
0