Why does '*select count(id) from "tblContacts"'* do a sequential scan
when the field '*id*' is indexed using a btree?
MySql simply looks at the index which is keeping a handy record of the
number of rows.
Can anybody explain how and why postgres does this query like it does?
Many thanks
Paul