Subject Select count(*) using pk
Author dirknaudts
Hi All,

It seems that doing a select count(*) from mytable, where mytable has
a pk, FB 1.5.1 doesn't use that PK to speed up the count.

Is this correctly observed ? Is there anything I can do to have a
faster count of table records ? (now table has about 200k records in
it, and it takes +6sec to count them) There are a lot of
inserts/deletes taking place on this table.


(PK is a generator feeded integer value)

Thanks,

Best regards,
Dirk Naudts.