Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is merge join cartesian more cpu intensibe than nested loop ?

698658Apr 27 2012 — edited Apr 27 2012

Hi,
just wonderning which access method is more cpu intensive , lets supposed we got 2 the same row sources and doing joing via merge join cartesian and next case is nested loop .
I know NL can be cpu intensive because of tight loop access , but what abour MJC ?
I can see bufferd sort but not sure is that cpu friendly ?
Regards
GregG

This post has been answered by amardeep.sidhu on Apr 27 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 25 2012

Added on Apr 27 2012

#general-database-discussions

10 comments

703 views