[EMAIL PROTECTED] writes:
> MySQL is using some sort of auto-clustering ISAM on the other box mayhaps?
I think they probably count the index entries without ever visiting the
table proper. Works great for mainly-static data ...
regards, tom lane
-
"James DeMichele" <[EMAIL PROTECTED]> wrote ..
> Then, I have the following index on the table:
> "this_index" (status, source_id, )
If you have many queries of this type, do
CLUSTER this_index ON tablename;
and retry the SELECT.
MySQL is using some sort of auto-clustering ISAM on the other
"James DeMichele" <[EMAIL PROTECTED]> writes:
> I am having a really hard time trying to figure out why my simple
> count(*) query is taking so long. I have a table with 1,296,070 rows in
> it. There are 2 different types of information that each row has that I
> care about:
Hmm, the EXPLAIN outpu
