Re: Subquery (IN) is more efficient than JOIN
From: Bill Ferguson <wbfergus_at_gmail.com>
Date: Thu, 2 Jun 2011 06:48:40 -0600
Message-ID: <BANLkTinf9W=e+3w9RwtSogpQ0w1h4uhT2w_at_mail.gmail.com>
On Wed, Jun 1, 2011 at 5:01 PM, Matt McClernon <mccmx_at_hotmail.com> wrote:
>
>> Your output was hard to read, but the CBO IN operation has a SORT UNIQUE step that the simple RBO join doesn't have.
> hmm, it must have got mangled when I pasted it in, does this look any better:
Date: Thu, 2 Jun 2011 06:48:40 -0600
Message-ID: <BANLkTinf9W=e+3w9RwtSogpQ0w1h4uhT2w_at_mail.gmail.com>
On Wed, Jun 1, 2011 at 5:01 PM, Matt McClernon <mccmx_at_hotmail.com> wrote:
>
>> Your output was hard to read, but the CBO IN operation has a SORT UNIQUE step that the simple RBO join doesn't have.
> hmm, it must have got mangled when I pasted it in, does this look any better:
Depending on mail clients used, the problem is probably due to HTML formatting. Maybe wrapping output with <pre></pre> tags would work?
To experiment, I'll try a little sample below: <pre> <----- there is a pre tag here
column_1 column_2 Column_3 <---- each 'header' has five spaces value1 value2 value3 <---- the firstletter was lined up under the first letter of the header </pre> <----- the ending pre tag
So, depending on what this looks like after I click send 'may' help explain formatting problems?
-- -- Bill Ferguson -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 02 2011 - 07:48:40 CDT