Hi Joel Garry,
- Well I used OEM to find out the problematic SQL.
- I resolved it by finding the the satetemnt in OEM and I added the
index and right
after I added it (without restart the test) my hits/second in Load
Runner growd
up from 1 hit/second to 20 hits/second which is the performance that
was on start of
test. I also tried test it again and there is no degradation any
more in my
application.
- Yes UPPER cause to full table scan (before I added function based
index), but I just
want to understand why degradation?
- Maybe it is poor design, but I'm not a architecture of company :-)),
I'm just regular
programmer that try to find out the performance problems in existing
for years
application.
Thanks,
Maxim.
Received on Thu Apr 14 2005 - 04:50:43 CDT
