On Tue, 2 Apr 2002, Dan Langille wrote:
> 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.
I also meant to ask: Do you have any indexes? On id? On somestring?