From: fvanbortel@netscape.net   
      
   Jim Kennedy wrote:   
   > "Geetha"  wrote in message   
   > news:4b40e20a.0310290724.13e86079@posting.google.com...   
   >   
   >>I searched in the Oracle documents what count (1) meant and I could   
   >>not find an answer.  Can some one explain what Oracle does internally   
   >>when use count (1) VS count (*).  Thank you very much in advance! We   
   >>use Oracle 9i.   
   >   
   > There is a myth out there that count(1) is faster than count(*).  It isn't   
   > true.  Use count(*).(You can look it up on asktom.oracle.com)   
   > Jim   
   >   
   >   
   Well, as it is a myth, you might just as well count(1) ;-)   
   As long as you do not expect (or -even worse- explain!) it   
   to be faster   
      
   --   
   Regards, Frank van Bortel   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)