Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Difference between count(1) and count(*)

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US