Subject Re: [ib-support] Record Count
Author Woody
From: "Ann W. Harrison" <aharrison@...>
> Are you sure? Do remember that count(*) and count(<field>) are
> not the same. Count(*) returns the number of rows in the table
> while count(<field>) returns the number of rows which have a non-null
> value for <field>. As for the index, though it will help in other
> databases, Firebird and InterBase can not use an index to accellerate
> a count.

Not even when using a WHERE clause? Are you sure? I would have thought that
as long as some criteria were specified which could use an index, then it
would use one. I admit, I haven't tested it so I don't know. I was just
"assuming". <g>