Re: Analyze -Command

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 30 Dec 1999 08:11:21 GMT
Message-ID: <386b12f5.1019605@news.demon.nl>

On Thu, 30 Dec 1999 08:59:22 +0100, "Christian Bühl (Veltrup)" <no_buehl_spam_at_veltrup-online.nospam.de> wrote:

>Can anyone tell me the Syntax of the Command Analyze.
>I read that this command must be executed to start the internal optimizer of
>Oracle 8. But i did not found any further description of this command. (I
>need to optimize because oft the very bad reaction times (with only 5 Users)
>in my ERP Application)
>
>thanks
>Chris
>
>

ANALYZE TABLE <table_name> COMPUTE|ESTIMATE statistics ANALYZE INDEX <index_name> COMPUTE|ESTIMATE statistics ANALYZE CLUSTER etc.

or (all tables/index in one go)
exec dbms_utility.analyze_schema('<SCHEMANAME>','COMPUTE')

Do you have a manual at all?
Otherwise please subscribe to
technet.oracle.com
Hth,

Sybrand Bakker, Oracle DBA Received on Thu Dec 30 1999 - 02:11:21 CST