Re: Analyze -Command

From: Erik Trolle <erik_trolle_at_hp.com>
Date: Thu, 30 Dec 1999 17:04:14 +0800
Message-ID: <84f74d$kqh$1@web1.cup.hp.com>

Syntax is

      ANALYZE  TABLE  table_name  COMPUTE STATISTICS
      ANALYZE INDEX  index_name  COMPUTE STATISTICS

You can replace COMPUTE with ESTIMATE for speed

Remember to ANALYZE again when the number of rows changes dramatically, ANALYZE looks an number of rows and distribution.

This may solve your problem, but more important is to look at INDEXes and CONSTRAINTs and that these are enabled.

Erik

Christian Bühl (Veltrup) wrote in message <84f37m$c53$1_at_news08.btx.dtag.de>...
>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
>
>
Received on Thu Dec 30 1999 - 03:04:14 CST