Timur has worked as a Performance Engineer and then Performance Architect for many years helping customers to achieve their performance requirements with enterprise applications. He is an Oracle Apps Database Consultant with Pythian helping clients to get stability and performance with their Databases and Middleware. Timur blogs irregularly at http://timurakhmadeev.wordpress.com, @tmmdv and http://www.pythian.com/blog/author/akhmadeev. He is an OakTable member since 2010.
SQL Optimization Walk Through
Live demo will show how to optimize typical SQL in a real database.
We’ll take a few real SQLs and will walk through the steps required to understand why SQL is running slower than it should, why Oracle is doing what it does, and possible solutions to these issues.