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
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_