Thanks a lot Shawn. As always, your advice has been very helpful.
On 2/3/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
>
> Scott Klarenbach <[EMAIL PROTECTED]> wrote on 02/02/2006 02:01:11
> PM:
>
> > I have a table `requirement` which is left joining to a table
> `inventory`
> > based on
Scott Klarenbach <[EMAIL PROTECTED]> wrote on 02/02/2006 02:01:11
PM:
> I have a table `requirement` which is left joining to a table
`inventory`
> based on a matching `partNumber` column. The inventory table has
millions
> of records, the requirement table has tens of thousands. I'm noticing
Try this:
[EMAIL PROTECTED]:ule> select * from a;
++--+
| id | data |
++--+
| 1 | a|
| 2 | b|
| 3 | c|
| 4 | d|
| 5 | e|
++--+
5 rows in set (0.00 sec)
[EMAIL PROTECTED]:ule> select * from b;
++--+
| id | data |
++--+
| 1 | aa |
I have a table `requirement` which is left joining to a table `inventory`
based on a matching `partNumber` column. The inventory table has millions
of records, the requirement table has tens of thousands. I'm noticing that
the left join between requirement and inventory doesn't take advantage of
