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
I'm nearing the end of my rope trying to figure this one out. I have
some queries run against a table that is a log of hits from a web
server. No matter how simple I've tried to make my query, MySQL sill
does not choose an index. Even use index has no effect.
My table:
CREATE TABLE access_log
