Re: Difference between count(1) and count(*)

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Thu, 8 Jul 2004 15:51:52 +0300
Message-ID: <027001c464ea$579d2da0$bff923d5@porgand>

> What exactly would we use a COUNT(NULL) for as it always returns 0?

That was exactly my point, that there are certain "experts" who "tune" your system by wild guessing and thus may even corrupt your data or application functions...

Tanel.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 08 2004 - 07:49:00 CDT