Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance degradation
Hi pobox,
Actually I do it like your second option. But I think I don't
need solution, I already found it by adding index, there is no
more degradation (at least not after 2-3 hours :) )
All I want is a good explanation for "why the index solved
degradation?"
I mean same SQL on same table should take same time right
after restart and after 2-3 hours of work. Or I miss something?
Thanks,
Maxim.
Received on Thu Apr 14 2005 - 04:41:59 CDT