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