Real-Life SQL Tuning: From Four Minutes to Eight Seconds in an Hour
Details
| Title | Real-Life SQL Tuning: From Four Minutes to Eight Seconds in an Hour |
| Author | Oracle Developers |
| Duration | 41:19 |
| File Format | MP3 / MP4 |
| Original URL | https://youtube.com/watch?v=9bHAeKiFctg |
🎵 Support the artists — buy the original for the best audio quality! 🎵
Description
Liron Amitzi, Senior Database Consultant, Brillix LTD
In 20 years of SQL tuning, this session’s speaker has learned many things. The number of elements that affect query tuning is huge: tables’ structure, indexes, optimizer behavior, and the SQL text itself are only some of them. This session takes a deep dive into specific examples of SQL tuning, based on real-life experience. Together, he and the audience members will identify a problem, analyze it (from understanding the schema and the application logic to looking at the object structure and SQL text), and fix it, while learning techniques and gaining some best practices for performance tuning.
