Re: MySQL LEFT JOIN Optimization Using LIMIT CLAUSE

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

Re: MySQL LEFT JOIN Optimization Using LIMIT CLAUSE

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

Re: MySQL LEFT JOIN Optimization Using LIMIT CLAUSE

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 |

MySQL LEFT JOIN Optimization Using LIMIT CLAUSE

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

Re: join optimization

com>cc: [EMAIL PROTECTED] Subject: Re: join optimization 09/19/2003 04

Re: join optimization

[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.

join optimization

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

Join optimization

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

join optimization

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

RE: JOIN optimization

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

Re: JOIN optimization

>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

JOIN optimization

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

Join optimization problem

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