Re: Analyze in Oracle 8.0.5

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 11 Jan 1999 11:31:50 +0800
Message-ID: <369970A6.223C@bhp.com.au>

Eddie Johnson Jr. wrote:
>
> Just installed Oracle 8.0.5 and it is working fine. I was informed that to
> analyze needs to be applied to assist in the ongoing process of optimizing
> and tuning. Could someone point a novice dba in the correct direction on
> using and installing analyze?
>
> Thanks In Advanced,
> edjohnjr_at_cwix.com

"analyze" just updates the statistics for each index/table etc that are used by the optimiser to determine the best way to get your data...

Check in the "ANALYZE" command (its DDL) in the SQL Reference Manual...but briefly:

analyze table XYZ compute statistics;

• do all the stats for the table (and its indexes) by scanning the whole table (ie an accurate but slower calculation)

analyze table XYZ estimate statistics;

• do all the stats for the table (and its indexes) by scanning a portion (ie a less accurate but quicker calculation)

You can also do "analyze index" etc etc

--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Sun Jan 10 1999 - 21:31:50 CST