SQL Performance (MOSC)

MOSC Banner

query with merge join Cartesian

edited Jun 1, 2018 9:16AM in SQL Performance (MOSC) 3 commentsAnswered ✓

Hello gurus,

     I would like understand "merge join cartesian", i know that it is that i have not any link betwen 2 tables.

but i do not understand how may i find it, but for me i think all the tables of my query have link.

and i would like understand if it is the only problem in my query because this query is very slow. ( average 45' ).

i join you the all query in the log file.

Best regards

JP

|*  2 |   HASH JOIN             |                         |   126M|    27G|   236M|  1446K  (1)| 04:49:21 |                                                                                            

|*  3 |    HASH JOIN            |                         |  1907K|   214M|   103M| 36748   (1)| 00:07:21 |                                                                                            

|   4 |     TABLE ACCESS FULL   | W_GL_ACCOUNT_D          |  1907K|    81M|       | 23046   (1)| 00:04:37 |                                                                                            

Tagged:

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center