Simple tuning example but uncertain test results

(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 More - Register for Free Membership