Re: database slow after upgrade. advice ?

srallapally_at_netscape.net schrieb:
>
> Hello,
> I recently upgraded my database from 7.2.3 t 7.3.3.0. The upgrade went okay,
> but the users have been complaining that queries which used to run fast
> prior to the upgrade run much slower !! the only change that i made before
> starting the instance and opening the database (after the upgrade) was to
> change the optimizer_mode to choose instead of rule.
> Any suggestions anyone ?
>

When did you analyze your objects for the last time?

HTH
Matthias
--
grema_at_t-online.de

Es gibt nichts Neues mehr.
Alles, was man erfinden kann, ist schon erfunden worden. Charles H. Duell, Leiter des US Patentamtes bei seinem Rücktritt 1899 Received on Thu Feb 25 1999 - 02:13:34 CST