Re: mysql using wrong indexing keys

2003-03-18 Thread Paul DuBois
At 22:23 -0800 3/18/03, Steve Quezadas wrote: I am running this query that is awfully slow. It's a simple query between two heap tables with two joins. I ran a "explain" statement to see why it is running so slow and realized that mysql was using indexing for one of the lesser inefficient join

mysql using wrong indexing keys

2003-03-18 Thread Steve Quezadas
I am running this query that is awfully slow. It's a simple query between two heap tables with two joins. I ran a "explain" statement to see why it is running so slow and realized that mysql was using indexing for one of the lesser inefficient joins! I fixed this problem by adding a STRAIGHT_