Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Merge join question

Re: Merge join question

From: Doc Waters <davidmwaters_at_yahoo.com>
Date: 23 May 2006 16:27:43 -0700
Message-ID: <1148426863.478191.324130@j73g2000cwa.googlegroups.com>


They can be faster when the rows are already sorted and perform well on an inequality condition (>= > <= <)

Oracle's help is useful on this one
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/optimops.htm#49759 Received on Tue May 23 2006 - 18:27:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US