RE: Why isn't Oracle Using My Index

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
  • Date: Thu, 21 Dec 2006 12:40:04 -0700

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 

Other related posts: