Horton

Re: "select count(*) from contacts" is too slow!

nolan@celery.tssi.com

View thread View on postgr.es
From: nolan@celery.tssi.com
To: nandrews@investsystems.co.uk (Nigel J. Andrews)
Cc: paul.serby@clockltd.com (Paul Serby), pgsql-general@postgresql.org
Date: 2003-10-07T23:21:17Z
Lists: pgsql-general 
> MySQL can tell you from it's index because it doesn't care if it gives you the
> right number or not.

Under what circumstances would MySQL give the wrong number?  
--
Mike Nolan