MySQL Forums
Forum List  »  Performance

Re: Query problem (update by author)
Posted by: KimSeong Loh
Date: October 22, 2004 04:07PM

Can you do a
EXPLAIN SELECT DISTINCT tableB_ID FROM matchTable WHERE tableA_ID IN(12,16,20,20030,254177)
and see how MyAQL executes the query with and without your combined index.

What was the combined index you had removed?

An index on (tableA_ID,tableB_ID) looks like a good candidate for this query.

Options: ReplyQuote

Written By
October 22, 2004 07:32AM
Re: Query problem (update by author)
October 22, 2004 04:07PM
October 22, 2004 04:14PM

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.