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 -> compute statistics for a big table for the first time

compute statistics for a big table for the first time

From: cris <cris119_at_operamail.com>
Date: Thu, 27 Feb 2003 12:16:42 +0100
Message-ID: <b3krvq$3hq$1@panco.nettuno.it> 





I wish to compute statistics for a big table (more than one million 
record) that was never analyzed.


I'm wondering if a single 'ANALYZE TABLE ... COMPUTE STATISTICS' 
statement is too heavy for my server and if it's better to analyze a 
single partition at a time (the table is partitioned).
Any hints would be appreciated.



Platform: SuSE Linux SLES7


Oracle version: 9.0.1.3


Hardware: Pentium III 996.894 MHz 878 MB RAM, RAID5



Kind regards, Cris
Received on Thu Feb 27 2003 - 05:16:42 CST












Original text of this message













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