Daly
- Original Message -
From: "Rob Wultsch" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, October 03, 2007 1:30 AM
Subject: Re: Multipart + IN comparison on the second part + JOIN does not
use full index
: It is way past bed time so excuse me if I am way off...
:
:
ginal Message -
From: "Rob Wultsch" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, October 03, 2007 1:30 AM
Subject: Re: Multipart + IN comparison on the second part + JOIN does not
use full index
: It is way past bed time so excuse me if I am way off...
:
: What is the order of
It is way past bed time so excuse me if I am way off...
What is the order of tables in the explain? What is shown as the select_type?
On 10/2/07, Eamon Daly <[EMAIL PROTECTED]> wrote:
> Hi, all. I couldn't find this mentioned in the docs or in
> the archives, so I'd figure I'd ask. I have a t
Hi, all. I couldn't find this mentioned in the docs or in
the archives, so I'd figure I'd ask. I have a table with a
multipart index on three columns. When querying the table
alone using IN operators on any of the three columns, all
parts of the index are used. However, if I do a JOIN with
another