Re: Database is extremely slow

"Scott Ashby" <Scott.Ashby_at_SMNA.com> wrote in message news:bd74662.0306250453.f13d73f_at_posting.google.com...

> I have an Oracle 7.3.4.4 database that is experiencing extremely slow

Ah OK. No point going into details, then.

> 1. The Optimizer_Mode parameter for Oracle is set to RULE. Does this
> mean that the server does not rely on statistics stored in the catalog
> when it is putting together the execution plan for a query? I am
> considering changing this to CHOOSE. Can I do this without having an
> adverse effect on performance or changing query results?

Most likely no.

>
> 2. Should I go ahead and rebuild the indexes on the tables that I
> know have been radically reduced in row count?

Yes.

>
> This system has never performed well, it is running on older, obsolete
> hardware and software, and a replacement system for it has been
> targeted and is being tested as I write this, but does anyone out

Hurry up then.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam