would be great here, but I've neer had
much luck with those, and a few times I've had results returned that
were wrong with a multi column index on the table.
Thanks for looking at this,
Mike
-Original Message-----
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Monday,
What percentage of your database contains rows where status = 200? It looks
to me like MySQL is estimating that perhaps 1/3 or more of the rows have that
status and therefore, it is faster to simply do a table scan rather than
using an index.
On Monday 25 March 2002 1:08 pm, Michael C. Neel w
