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: Analyze Command

Re: Analyze Command

From: GMAN <gman_at_siscom.net_NOSPAM>
Date: Tue, 1 Sep 1998 18:02:19 -0400
Message-ID: <SfZG1.852$g4.2678506@news.siscom.net> 





I agree with the other messages, with the understanding that the data is
changing.  The more frequently the data changes, large large, high volume
OLTP, mass deletes, etc, the more frequently you should run Analyze...



My opinions are my own...



George Spears





Josef Huber wrote in message <35ec2001.0_at_news.profinet.at>...


>Hello,


>


>Does ANALYZE tables/indexes need to be executed periodically ?!


>


>Cioa,


>Joe


>


>


>




Received on Tue Sep 01 1998 - 17:02:19 CDT












Original text of this message













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