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


Subject
Views
Written By
Posted
3583
October 22, 2004 07:32AM
Re: Query problem (update by author)
2203
October 22, 2004 04:07PM
2460
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.