Re: Subquery (IN) is more efficient than JOIN

From: Bill Ferguson <>
Date: Thu, 2 Jun 2011 06:48:40 -0600
Message-ID: <>

On Wed, Jun 1, 2011 at 5:01 PM, Matt McClernon <> 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 first
letter 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
Received on Thu Jun 02 2011 - 07:48:40 CDT

Original text of this message