Re: how to speed up a "select count(*) from ..."

> I have a table with 40.000 records. There was no primary key on the table
> (!) and a "select count(*) from mytable" took about 15 sec.
> So, now, I've created a primary index on mytable.id field...
>
> Well... it still takes 15 sec to count the records... :-(

You could try to use "select count(1) from mytable", but I never tried how much faster this is.

Stephan Schlecht

--
Software 7 GmbH
Regensburg          
http://www.software7.de