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 -> ANALYZE_DATABASE - Query ...

ANALYZE_DATABASE - Query ...

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Wed, 17 Jul 2002 15:16:58 +0100
Message-ID: <u%eZ8.2786$zX3.2308@news.indigo.ie> 





The following text puzzled me .





it's 9.2 supplied package reference DBMS_UTILITY section





ANALYZE_DATABASE Procedure



This procedure runs the ANALYZE command on all the tables, clusters, and
indexes



in a database. Use this procedure to collect nonoptimizer statistics. For
optimizer



statistics, use the DBMS_STATS.GATHER_DATABASE_STATS procedure.





Q : What's a nonoptimizer statistic ?
Received on Wed Jul 17 2002 - 09:16:58 CDT












Original text of this message













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