On Tue, 2 Apr 2002, [iso-8859-1] Alexander Havng wrote:
> When I do a query, say,
> SELECT count(id) FROM bigtable WHERE somestring='something';
> then what I would expect from the database is that it would completely hog the cpu
> and disk i/o for a while until the query is completed, which on this machine well..
> should take one or two minutes. Instead, it takes 12 minutes.
Out of interest, what results do you get from select count(*) ...? I
would expect it to be faster.