I had been using EXPLAIN. And USE INDEX. With it without USE INDEX, a month or half-a-month, it still uses the correct index. I'll try FORCE INDEX, though.
Wade.
After some MySQL clues.
- (static)
- (4)
- May 16, 2007, 09:14:39 PM EDT
What I'd do
- (drewk)
- (3)
- May 16, 2007, 11:07:16 PM EDT
I approached that from another direction.
- (static)
- (2)
- May 17, 2007, 12:09:44 AM EDT
Re: I approached that from another direction.
- (dws)
- (1)
- May 17, 2007, 01:41:19 AM EDT
FORCE INDEX is new to me.
- (static)
- May 17, 2007, 08:40:14 AM EDT