Jeff,
Try creating a new index on Question containing just the question_key field,
and try it again.
Andy
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: 22 September 2003 13:23
> To: [EMAIL PROTECTED]
> Subject: join not using first
I have four tables that i'm trying to join together most are pretty
small(100-200 rows tops) and one, the Response table is 127,000 rows. The
query i'm currently executing is
SELECT Business_Unit.Business_Unit, Question.Text_Long, AVG(Response) from
Question
INNER JOIN Response on Question.Questi
