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
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
for looking at this,
Mike
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 3:13 PM
To: Michael C. Neel; [EMAIL PROTECTED]
Subject: Re: MySQL not using an index
What percentage of your database contains rows where status = 200