Re: compute statistics for a big table for the first time

From: chan01 <chandra_2000_us_at_yahoo.com>
Date: 27 Feb 2003 15:17:54 -0800
Message-ID: <480cb9d4.0302271517.46e3821a@posting.google.com>

Better use the dbms_stat package to analyze the table,indexs and do partition by partition.

Good Luck.

cris <cris119_at_operamail.com> wrote in message news:<b3krvq$3hq$1_at_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 - 17:17:54 CST