RE: count(*)

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Thu, 26 Oct 2000 11:24:44 -0400
Message-Id: <10661.120291@fatcity.com>

Lisa,
I don't see why there would be a difference either. Also, autotrace gives the same execution plan and statistics for both.

Henry

-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com] Sent: Thursday, October 26, 2000 11:16 AM To: Multiple recipients of list ORACLE-L Subject: count(*)

good morning -

What query uses less resources:

select count(*) from table;

select count('x') from table;

I don't think there is a difference, the plans are the same, and both are not column specific.
Comments anyone?

Thanks

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174 
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com <http://www.qode.com>

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." Received on Thu Oct 26 2000 - 10:24:44 CDT