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