SQL Performance (MOSC)

MOSC Banner

help with sql tuning

Dear Team,

This query has been taking along of CPU, is there anyway to further reduce cost ? Thanks in advance !!                                                                                                                           

select COUNT(distinct ABC.APPL_ID) from CS_CASE_INFO ABC,                                                                                                                          

REP_REPOSSESSION_M CDB ,REPO_DISPOSE_DETAILS DAS where queue !=                                                                                                                      

'COMM' and CASE_CLEAR_FLAG = 'N' and DELINQUENT_FLAG = 'Y' and                                                                                                                        

NVL(ABC.REPO_FLAG,'N')='Y' and ACTIVITY ='DATB' and ABC.APPL_ID =                                                                                                                      

CDB.APPL_ID and ABC.CUST_ID= CDB.CUST_ID and ABC.CS_CASE_INFO_ID                                                                                                                       

=CDB.CS_CASE_INFO_ID and DECODE(CDB.DISPOSAL_TYPE,'B','1',CDB.BATCH_ID)                                                                                                                   

in (select DECODE(CDB.DISPOSAL_TYPE,'B','1',BATCH_ID) from                                                                                                                         

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