MySQL Forums
Forum List  »  Performance

Re: Optimizing a query to out-perform MS Access (easy, right?)
Posted by: Felix Geerinckx
Date: October 11, 2005 07:20AM

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.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.