SQL Performance (MOSC)

MOSC Banner

Find MERGE JOIN CARTESIAN

edited Oct 17, 2014 10:02AM in SQL Performance (MOSC) 1 commentAnswered

Hi All, I've a query that is producing a CARTESIAN product. This query never completes in production, but due to small data it completes in DEV.  Is there a way where I can find from the query where the problem is and the solution for that ?

The query is

explain plan for

SELECT CD.DECISIONFROMDATE , CD.DECISIONTODATE , CDG.CONCERNROLEID , PD.CASEID , CH.INTEGRATEDCASEID , CRAI.ALTERNATEID , P.DATEOFBIRTH , AN.SURNAME , AN.FIRSTFORENAME , CR.PREFERREDLANGUAGE , PD.PRODUCTTYPE , AIHN.ALTERNATEID , AIHN.CONCERNROLEALTERNATEID , CH.STATUSCODE ,

CD.RESULTCODE                              

FROM curam_s1_user.MCSSCASEDECISIONGROUP CDG

INNER JOIN curam_s1_user.CASEDECISION CD ON CDG.CASEDECISIONID= CD.CASEDECISIONID

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