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: Oracle 8i does NOT recommend using 'analyze table',is this true?

Re: Oracle 8i does NOT recommend using 'analyze table',is this true?

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 28 Feb 2003 06:05:44 +0100
Message-ID: <rcrt5vo9au0l1b7gv3b02r5d3qu35e3u5p@4ax.com> 





On 27 Feb 2003 20:24:26 -0800, mariocheung_at_msn.com (Mario Cheung)
wrote:



>And why ? thanks!



because ANALYZE has been superseded by the dbms_stats package
which 

- is capable of using multiple processors
- generates more accurate statistics
- has the option of working with various sets of statistics
- can analyze tables which have stale statistics only





regards




Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Thu Feb 27 2003 - 23:05:44 CST












Original text of this message













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