Poul Møller Hansen <freebsd@pbnet.dk> writes:
> My questions is, which statements can use to count the rows faster ?
> 32 secs compared to 10 ms !
Try starting a transaction in one window updating one of those records and see
how long it takes your count(*) to complete in the other window while that
update is still pending.
--
greg