Stream: Virtual Room 3
Time: 13:45 - 14:30
This session will introduce you to the core concepts of SQL performance tuning on IBM Z systems. We'll explore how to analyze and optimize query execution, access path interpretation, understand different tables used to analyze access paths, BIND/REBIND options, effective Index designs, optimizing complex SQLs and monitoring of SQL performance. We'll learn how to identify and resolve common bottlenecks. We'll cover practical tips and techniques that you can immediately apply to improve the speed of your applications, even if you're new to SQL.
There is currently no attachment for Mastering SQL Performance on IBM Z: Analyzing and Optimizing Queries for Maximum Throughput
Saurabh works as a Lead Product Manager at BMC Software. Saurabh is a Lead Product Manager at BMC Software. He is an IBM Champion 2025 and 2024. He has been working on IBM Z and Db2 for z/OS for past 19 years. He had been a Db2 DBA in the beginning of his career and later had worked on product development, people management, quality assurance, SQL Performance, change management, AI and Product Management, He has keen interest in face reading, astrology and body language.
Click here to give some Feedback so we can make it even better next year!