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

Home -> Community -> Usenet -> c.d.o.server -> Re: number of rows in a table

Re: number of rows in a table

From: <kal121_at_yahoo.com>
Date: Mon, 03 May 1999 17:40:15 GMT
Message-ID: <7gkn1v$afc$1@nnrp1.dejanews.com> 





COUNT(1) or COUNT(ROWID) are supposedly faster.



COUNT(*) requires internal checks that can cause a slowdown.



I've run some tests that seem to verify that the above two methods can be
faster on large tables.



-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own    
Received on Mon May 03 1999 - 12:40:15 CDT












Original text of this message













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