Re: Analyze Command

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Tue, 1 Sep 1998 18:46:11 -0700
Message-ID: <6si7oi$ni4@dfw-ixnews7.ix.netcom.com>

Only if you want to use oracle cost optimizer. If you intend to use the rule optimizer, there is no need to analyze the tables/indexes. In fact, it will mess up your rule optimizer if Oracle find the statistics of a certain table.

Winnie

Josef Huber wrote in message <35ec2001.0_at_news.profinet.at>...
>Hello,
>
>Does ANALYZE tables/indexes need to be executed periodically ?!
>
>Cioa,
>Joe
>
>
>
Received on Tue Sep 01 1998 - 20:46:11 CDT