SQL tuning in practice: From four minutes to eight seconds in one hour

SQL tuning in practice: From four minutes to eight seconds in one hour

HomeOracle DevelopersSQL tuning in practice: From four minutes to eight seconds in one hour
SQL tuning in practice: From four minutes to eight seconds in one hour
ChannelPublish DateThumbnail & View CountDownload Video
Channel AvatarPublish Date not found Thumbnail
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.