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 -> Re: Can someone please straighten me out on the COUNT function?

Re: Can someone please straighten me out on the COUNT function?

From: JoeZ53 <joez53_at_aol.com>
Date: 20 Jan 1999 20:31:18 GMT
Message-ID: <19990120153118.22195.00000105@ng-fi1.aol.com> 





One thing to note, if you have inserted and deleted a significant number of
rows in your table, count(*) will count through every block in the table up to
the high water mark even if it is empty.  I have seen queries against a temp
table take several minutes and return an answer of 0.  This is because at one
time the table may have had a couple million rows in it.
Received on Wed Jan 20 1999 - 14:31:18 CST












Original text of this message













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