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

Home -> Community -> Usenet -> c.d.o.misc -> Count(*) Versus Count(1)

Count(*) Versus Count(1)

From: Priya <supriyarshete_at_gmail.com>
Date: 2 May 2007 22:21:24 -0700
Message-ID: <1178169684.307229.18210@u30g2000hsc.googlegroups.com> 





Hi,



I Read on Many sites about Count (*) and Count(1). But there are
conflicts in the documents.


Some where it has been specified like count (*) gives better
performance and somewhere it is like Count (1) gives better
performance.



Can anybody please help me to understand how it works and which one is
better for performance?



Any help would be appreciated.



Thanks
Received on Thu May 03 2007 - 00:21:24 CDT












Original text of this message













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