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 -> help:dbms_stats vs. analyze

help:dbms_stats vs. analyze

From: a <dbadba62_at_hotmail.com>
Date: Fri, 04 Jan 2002 12:44:25 GMT
Message-ID: <JshZ7.6414$ym.1930@nwrddc01.gnilink.net> 





We have a scripts which will run every night to compare the num_rows in
dba_table with the count(*) of the target tables, if not equal, we will
analyze the table.



Is there any advantage to switch to dbms_stats in terms of analyze results?



Thanks for your help
Received on Fri Jan 04 2002 - 06:44:25 CST












Original text of this message













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