Nicolas Williams <[EMAIL PROTECTED]> wrote:
On Wed, Dec 13, 2006 at 01:33:35PM -0500, Igor Tandetnik wrote:
Nicolas Williams
<[EMAIL PROTECTED]>
wrote:
On Wed, Dec 13, 2006 at 06:07:56PM +0000, RB Smissaert wrote:
count(*) doesn't read every record in the table.
Does too. Run EXPLAIN and see for yourself.
Ah. Yes. It could optimize "select count(*) > 0 from sometable;" as
"select 1 from sometable limit 1;"...
If you are checking for existence, why not say so explicitly?
select exists (select * from sometable);
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------