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: Contents of DBA_HISTOGRAMS according to the ANALYZE cmd used

Re: Contents of DBA_HISTOGRAMS according to the ANALYZE cmd used

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 31 Jan 2005 06:40:15 -0800
Message-ID: <1107182415.570899.8520@f14g2000cwb.googlegroups.com> 





See the SQL manual for your version of Oracle.  Also the actual command
you used would have been a nice addition to your post.  If you are on
version 9+ you should consider using dbms_stats instead of analyze to
generate statistics.



Compare


analyze table x estimate statistics sample n rows
for all columns size 1



then later size 100, 255 to your current output and the default
estimate.



HTH -- Mark D Powell --
Received on Mon Jan 31 2005 - 08:40:15 CST












Original text of this message













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