Subject Re: [firebird-support] Re: SELECT COUNT performance
Author Doug Chamberlin
On 7/10/2010 8:14 AM, sqlsvr wrote:
> Thanks for the response. The resource states:
> Reason is that Firebird doesn't keep information about number of records in database. Since query doesn't have WHERE clause, it cannot use index either, and has to go through all the records.
> But my query DOES have a where clause (it is an indexed column) and it is very slow.

I haven't seen a where clause in this thread yet.

What is the SQL used? What is the table schema? What is the selectivity
on the index? How many records in the table?