Re: Difference between count(1) and count(*)
- From: ryan.gaffuri@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 08 Jul 2004 13:38:02 +0000
for some reason there appears to be more B.S. associated with performance
tuning than any other Oracle topic. People are far more likely to pull stuff
out of their asses on performance tuning than anywhere else...
-------------- Original message --------------
> I've actually seen an "expert" optimizing the count() statement, by using
> count(null) "since null means nothing and thus is the fastest" :)
>
> But check this:
>
> SQL> select count(*) from dual;
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
