Subject | Select count(*) using pk |
---|---|
Author | dirknaudts |
Post date | 2005-02-09T16:14:28Z |
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.
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.