Re: Optimizing a query to out-perform MS Access (easy, right?)

[Felix Geerinckx]

David Skalinder wrote:

> I've spent a lot of time on the tables already and posted their structure without getting any
> feedback, so I'm inclined to assume #2 from here.

Going back to your original post, have you tried a covering index on table r, i.e. one of

ALTER TABLE r ADD UNIQUE (r_id, q_id, a_id);
ALTER TABLE r ADD UNIQUE (r_id, a_id, q_id);

I don't know if it would be used in this case though.

--
felix
Please use BBCode to format your messages in this forum.