Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow down of query?
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