Merge Join Cartesian
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Merge Join Cartesian

Threaded View

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    Merge Join Cartesian

    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
    Attached Files Attached Files
    Cheers!
    OraKid.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width