Poul Møller Hansen <freebsd@xxxxxxxx> 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
