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