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

Home -> Community -> Usenet -> comp.databases.theory -> Re: counting rows

Re: counting rows

From: Tony Andrews <andrewst_at_onetel.com>
Date: 1 Apr 2006 03:37:33 -0800
Message-ID: <1143891453.767287.295100@i39g2000cwa.googlegroups.com> 





Tony Rogerson wrote:


> Number 2 will be best because you are effectively storing the aggregate

> instead of the server having to count the number of rows in the table which

> would require IO.




That is wildly simplistic.  Based on that advice, it would be "best" to
always store the count, sum, min, max, avg, etc. of everything in its
parent table(s).  Please tell me you don't!?
Received on Sat Apr 01 2006 - 05:37:33 CST












Original text of this message













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