Carlos Sierra's Tools and Tips

Have you ever wondered what is the “right way” to gather statistics for the Optimizer? Well, actually there is no “right way”. When someone asks me “how should we gathered statistics?”, my answer always is: “it all depends”.

Mauro Pagano is presenting at the Central Florida Oracle Users Group (CFOUG) meeting this coming Monday, July 23 at 6:00 PM, in Orlando, Florida. His topic is: “A healthy approach to optimizer statistics: 11g improvements and common concerns you should know about”. This presentation covers interesting features in 11g, but most important: what works well and what works almost well when it comes to statistics gathering. Mauro is one of the best engineers supporting query tuning (QTUNE) at Oracle. At his present role, he has seen many issues concerning statistics. Thus Mauro has a pretty good idea of what works best and  in which conditions. He will also talk about common misconceptions and mistakes.

If you are in the Central Florida area, please contact the CFOUG to attend this valuable session. Power point will be available through the CFOUG web page after the presentation.