Hi All
Can someone explain about "MERGE JOIN CARTESIAN"
SELECT STATEMENT, GOAL = CHOOSE Cost=7 Cardinality=1 Bytes=287
TABLE ACCESS BY INDEX ROWID Object owner=EDW_2_3_0 Object name=C_REFERENCE Cost=2 Cardinality=1 Bytes=67
NESTED LOOPS Cost=7 Cardinality=1 Bytes=287
NESTED LOOPS Cost=5 Cardinality=1 Bytes=220
MERGE JOIN CARTESIAN Cost=4 Cardinality=1 Bytes=120
TABLE ACCESS FULL Object owner=EDW_2_3_0 Object name=IMEI_DEALER Cost=2 Cardinality=1 Bytes=102
BUFFER SORT Cost=2 Cardinality=82 Bytes=1476
TABLE ACCESS FULL Object owner=EDW_2_3_0 Object name=VOUCHER_PAYMENT Cost=2 Cardinality=82 Bytes=1476
TABLE ACCESS BY INDEX ROWID Object owner=EDW_2_3_0 Object name=PIVOT_SUBSCRIBER_DETAIL Cost=1 Cardinality=1 Bytes=100
INDEX UNIQUE SCAN Object owner=EDW_2_3_0 Object name=PK_PIVOT_SUBSCRIBER_DETAIL Cardinality=35776
INDEX RANGE SCAN Object owner=EDW_2_3_0 Object name=C_REFERENCE_TYPE_ID_IDX Cost=1 Cardinality=98
Thanks