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: Mike Mountjoy <michael_at_london.virgin.net>
Date: Tue, 1 Sep 1998 17:48:27 +0100
Message-ID: <6sh8ag$mg$1@nclient3-gui.server.virgin.net> 





In a word Yes.



Analyze table <table_name> compute statistics  should be run fairly often
since the cost based optimiser uses these stats as a basis for its choice
of execution plan.



Regrds



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 - 11:48:27 CDT












Original text of this message













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