Message-Id: <10711.124745@fatcity.com> From: "Sanjay Kumar" Date: Fri, 15 Dec 2000 11:54:35 -0800 Subject: Count(*) Vs Count(1) This is a multi-part message in MIME format. ------=_NextPart_000_0019_01C0668D.CB51C710 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I issed the following two statements and generated a plan using Explain = Plan. The table on which I tried this query was v$cache. Select Count(*) from v$cache Select Count(1) from v$cache I found that the explain plan generated the same plan for both the = statements. Does that mean that both the statements are equally = efficient. In my opinion, I feel that Count(1) is better than Count(*). Kindly explain. Thanks Rgds Sanjay ------=_NextPart_000_0019_01C0668D.CB51C710 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I issed the following two statements = and generated=20 a plan using Explain Plan. The table on which I tried this query was=20 v$cache.

Select Count(*) from = v$cache

Select Count(1) from = v$cache

I found that the explain plan generated = the same=20 plan for both the statements. Does that mean that both the statements = are=20 equally efficient.

In my opinion, I feel that Count(1) is = better than=20 Count(*).

Kindly explain.

Thanks

Rgds

Sanjay