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 -> Not analyzing tables with nearly fixed size?

Not analyzing tables with nearly fixed size?

From: Holger Marzen <holger_at_marzen.de>
Date: 2 Jun 2004 14:06:52 GMT
Message-ID: <c9kmts$uov$1@bluebell.marzen.de> 





Given a table where new data is inserted and old data is purged
periodically.



Is it wise to gather stats frequently or is it ok to save the cpu cycles
and analyze only once, when the table's got its final size?
Received on Wed Jun 02 2004 - 09:06:52 CDT












Original text of this message













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