SQL tuning in practice: From four minutes to eight seconds in one hour
Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
Liron Amitzi, Senior Database Consultant, Brillix LTD
In 20 years of SQL tuning, the speaker of this session has learned a lot. The number of elements that affect query tuning is enormous: table structure, indexes, optimizer behavior, and the SQL text itself are just a few of them. This session will go into depth with specific examples of SQL tuning based on real-world experience. Together with the audience, he will identify a problem, analyze it (from understanding the schema and application logic to looking at the object structure and SQL text), and fix it while learning techniques and some best practices for performance tuning.
Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.