Saturday, April 19, 2008

A recent email from a former student

I heard from Ken Deutschmann of Anheuser Busch and he made my day knowing he'd used knowledge and techniques from the Optimizing Oracle SQL, Intensive class. Here's what he had to say.

"I had always considered myself a decent query tuner/writer. But, I will have to say that I did pick up some nice little tidbits that I have been making use of - like using GROUP BY's in subqueries to force no rewrites, etc. One case I did today was to drop a query from 3.5MM I/O's down to 20K with just such a change. Knowing more about the 10046 trace output is very helpful. I have been helping my main application group in tuning their stuff, most often droping run times in half or better. "

Right on Ken, you go brother!!!


Gary Goodman said...

I love it! Results are the only thing that matter.

Anonymous said...

Can you share the sql or reproduciable example with your findings?

Ric Van Dyke said...

Sorry the company where the student works will not allow the code to be published. A representative example is not possible.