Search SSWUG.ORG:



DATABASES

Simple tuning example but uncertain test results This is an off-site link.  Please review our Terms of Service for additional information.


(Bobby Durrett) Last week I came across what seemed like a simple query tuning problem. A PeopleSoft batch job ran for many hours and when I did an AWR report I found that the top query was doing a full scan when an index should help.

Read this article..







comments powered by Disqus