[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
cc: [EMAIL PROTECTED]
Subject: Re: join optimization
09/19/2003 04:05 PM
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 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 column to Battery and