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_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 - 08:34:44 CDT
