Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: count(*)

RE: count(*)

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Thu, 26 Oct 2000 13:55:54 -0400
Message-Id: <10661.120316@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C03F75.FEC29564
Content-Type: text/plain;

        charset="iso-8859-1"

Thanks, Steve and Henry. You confirmed my thoughts.

I may have serious problems, but they don't include Oracle 6... !

GO VIKINGS! 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

"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."

-----Original Message-----
From: Steve Orr [mailto:sorr_at_arzoo.com]
Sent: Thursday, October 26, 2000 1:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: count(*)

I think it depends on your version of Oracle. It used to make a difference and the "secret" tuning tidbit was not to use count(*). Since then Oracle has optimized count(*). Now I think it's OK as long as you're not using version 6. (Does anyone know which specific release addressed this? Maybe as late as 7.1?) If you're still using version 6 then you probably have other, more serious problems.

Steve Orr

-----Original Message-----
Sent: Thursday, October 26, 2000 9:27 AM To: Multiple recipients of list ORACLE-L

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-----
Sent: Thursday, October 26, 2000 11:16 AM To: Multiple recipients of list ORACLE-L

good morning -

What query uses less resources:

select count(*) from table;

or

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."

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Henry Poras
  INET: Henry.Poras_at_ctp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Orr INET: sorr_at_arzoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C03F75.FEC29564 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: count(*)</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Thanks, Steve and Henry.&nbsp; You confirmed my = thoughts.</FONT> </P> <P><FONT SIZE=3D2>I may have serious problems, but they don't include = Oracle 6... !</FONT> </P> <P><FONT SIZE=3D2>GO VIKINGS!</FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL&nbsp; 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P> <P><FONT SIZE=3D2>&quot;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.&quot;</FONT></P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Steve Orr [<A = HREF=3D"mailto:sorr_at_arzoo.com">mailto:sorr_at_arzoo.com</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, October 26, 2000 1:01 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: count(*)</FONT> </P> <BR> <P><FONT SIZE=3D2>I think it depends on your version of Oracle. It used = to make a difference</FONT> <BR><FONT SIZE=3D2>and the &quot;secret&quot; tuning tidbit was not to = use count(*). Since then Oracle</FONT> <BR><FONT SIZE=3D2>has optimized count(*). Now I think it's OK as long = as you're not using</FONT> <BR><FONT SIZE=3D2>version 6. (Does anyone know which specific release = addressed this? Maybe as</FONT> <BR><FONT SIZE=3D2>late as 7.1?) If you're still using version 6 then = you probably have other,</FONT> <BR><FONT SIZE=3D2>more serious problems.</FONT> </P> <P><FONT SIZE=3D2>Steve Orr</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, October 26, 2000 9:27 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <P><FONT SIZE=3D2>Lisa,</FONT> <BR><FONT SIZE=3D2>I don't see why there would be a difference either. = Also, autotrace gives</FONT> <BR><FONT SIZE=3D2>the same execution plan and statistics for = both.</FONT> </P> <P><FONT SIZE=3D2>Henry</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>Sent: Thursday, October 26, 2000 11:16 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>good morning -</FONT> </P> <P><FONT SIZE=3D2>What query uses less resources:</FONT> </P> <P><FONT SIZE=3D2>select count(*) from table;</FONT> </P> <P><FONT SIZE=3D2>or</FONT> </P> <P><FONT SIZE=3D2>select count('x') from table;</FONT> </P> <P><FONT SIZE=3D2>I don't think there is a difference, the plans are = the same, and both are</FONT> <BR><FONT SIZE=3D2>not column specific.</FONT> <BR><FONT SIZE=3D2>Comments anyone?</FONT> </P> <P><FONT SIZE=3D2>Thanks</FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL&nbsp; 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933</FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A> &lt;<A = HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A>&gt;</FONT> </P> <P><FONT SIZE=3D2>&quot;The information contained herein does not = express the opinion or position</FONT> <BR><FONT SIZE=3D2>of Qode.com and cannot be attributed to or made = binding upon Qode.com.&quot;</FONT> </P> <P><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>--</FONT> <BR><FONT SIZE=3D2>Author: Henry Poras</FONT> <BR><FONT SIZE=3D2>&nbsp; INET: Henry.Poras_at_ctp.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) = 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from).&nbsp; You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information =
(like subscribing).</FONT>
</P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Steve Orr</FONT> <BR><FONT SIZE=3D2>&nbsp; INET: sorr_at_arzoo.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) = 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
Received on Thu Oct 26 2000 - 12:55:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US