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
com>cc: [EMAIL PROTECTED]
Subject: Re: join optimization
09/19/2003 04
[EMAIL PROTECTED] wrote:
I have two tables and am running a simple join between them to get
questions and their repsective response averages from a survey. The
question table has 49 rows and the Response table has 126,732. I'd like to
cut down on the time its taking to run this specific query.
I have two tables and am running a simple join between them to get
questions and their repsective response averages from a survey. The
question table has 49 rows and the Response table has 126,732. I'd like to
cut down on the time its taking to run this specific query...as i'll be
running many li
Hi folks,
I¹m wondering what (in general) causes a join to use temporary tables and
filesorts...
More specifically, what can I tune to avoid it? I can give more info about
a specific situation if anyone¹s interested.
All the docs say is that you are likely to get a ³Using temporary² if you
sort o
I would like to make a query that give me the following
result:
2 tables:
call
phone_number,dest_number,durantion
extention
phone_number,employee
I would like to have the followi
Hi Bob,
Many thanks for your answer, I was afraid that
due to the length of the mail, it would scare
everybody...
>>Battery:
>>* batID (primary key)
>>* makID
>>* descr
>>
>>Maker:
>>* makID (primary key)
>>* mak
>A battery can have only one manufacturer, so you might as well add
>the mak colu
>Hi,
>
>I'm rather new to SQL (well, I had a one-year course
>at the university many years ago, but they didn't
>teach us anything practical). I did a few very simple
>data bases, but now I'm moving to something more
>serious with joins and 'group by'. The idea is to create
>a search engine for a
Hi,
I'm rather new to SQL (well, I had a one-year course
at the university many years ago, but they didn't
teach us anything practical). I did a few very simple
data bases, but now I'm moving to something more
serious with joins and 'group by'. The idea is to create
a search engine for a battery
Hi,
Given this table:
create table occurrance (
word int unsigned not null,
document_id int unsigned not null,
offset mediumint unsigned not null,
key index_word (word),
key index_document_id (document_id),
key index_offset (offset)
) TYPE=MyISAM
..the following query
13 matches
Mail list logo