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

From: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date: Thu, 8 Jul 2004 07:23:40 -0700
Message-Id: <200407080723.40945.ltiu@alumni.sfu.ca>

On July 8, 2004 01:29 am, David Sharples wrote:
> You don't mention version but they are exactly the same
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:11561
> 59920245
>

But reading through the articles, it seems to me that there was a historial truth to count(1) being faster, but this has since become irrelevant due to advances.

Thanks for the info.

--
Lyndon Tiu
----------------------------------------------------------------
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 - 09:21:32 CDT