At 12:32 PM 12/21/2006, Mercadante, Thomas F \(LABOR\) wrote:
All I'm saying is that it may be something else. And tracing the application or performing a 10046 trace as Jared suggests while the application is running is a very useful exercise to determine what exactly the application is sending to Oracle.And I'm glad Wolfgang has time to respond to you. He is the best for debugging why the optimizer is doing what it is doing.
Thanks Tom, but I'm at best 2nd best, waaaayyy behind Jonathan. Still, I'm trying
Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com