Re: Problems running Oracle / Performance

Alexander Zbiek wrote:

> Rehi again,
>
> the Server now runs for a couple of days some changes here .. a few
> indexes
> dropped and recreated ... and ... it runs much faster now. (From
> Highload average of 5.00 down to 1.00 to 2.00) It does not run really
> great compared to
> the system it was installed before.
>
> And I really wonder why creating indexes anew would speedup DB use ..
> or is the
> analyze stuff still working and getting better performance over time?

That is the entire point of an index ... to speed of DML.

But nothing gets better over time except wine. You must create a job of some kind, perhaps with DBMS_JOB to keep the statistics fresh.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)