Re: MySQl 5.0 optimization problem

[Rob Wultsch]

On Fri, Apr 11, 2008 at 6:47 AM, Ben Clewett <ben@stripped> wrote:
> A COUNT() forces the system to read every row in order to count them...
That is not strictly the case.
A count(field) can use an index scan rather than a sequential scan,
which may or may not be faster. Also some count(field) can queries be
optimized away if a field is NOT NULL and the type is myisam.

Posting a
>Show status;
might be useful.

DDL is always helpful...
-- 
Rob Wultsch
wultsch@stripped
wultsch (aim)