Re: How often should we analyze several large tables.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 29 Aug 2001 07:28:17 +0200
Message-ID: <toovmmbig3hu33@news.demon.nl>

"Kate Lin" <linlin27_at_sympatico.ca> wrote in message news:gxWi7.28563$Hr2.2028991_at_news20.bellglobal.com...
> Hi,
> everybody. i just migrated oracle 7.3.2 to oracle 8.1.6. i found in an
old
> box, after a large batch job every day, it did a analyze table for several
> large tables (1 table over 36million rows)
> for example:
> analyze table rtu_data estimate statistics sample 10 percent ?
>
> is it necessary? if not , how often should i do?
>
>
> thanks advance
>
>
>
>

If the batch job performs *major* changes to the affected table, you will need to analyze the table.
If that batch job runs daily, you need to run the analyze daily.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Wed Aug 29 2001 - 00:28:17 CDT