Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance degradation

Re: Performance degradation

From: <zabutimaxim_at_gmail.com>
Date: 14 Apr 2005 02:41:59 -0700
Message-ID: <1113471719.113460.18640@g14g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US