Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Slow down of query?

Re: Slow down of query?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Apr 2002 06:33:18 +0200
Message-ID: <f1g7bu4eutege1bep8v8moehsfb8t4tob4@4ax.com>


On Wed, 10 Apr 2002 03:35:07 GMT, "Percival Boqais" <pb_at_microsoft.com> wrote:

>Thanks to those who replied. It is Oracle 8i. The DBA "analyzed" the
>database, use rule based <something> and now the entire database is quick.
>Amazing.
>
>~ PB
>

If the DBA uses the Rule Based Optimizer, care to explain why he analyzes the database? The Rule Based Optimizer *ignores* the statistics collected by analyze, and the RBO hasn't been changed since 1994.
Looks like the DBA also needs to learn Oracle.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Apr 09 2002 - 23:33:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US