Location | Delivered By | Language | Date | Price | Action |
---|---|---|---|---|---|
No schedule date's available now. |
* Prices Inclusive of taxes
Location | Delivered By | Language | Date | Price | Action |
---|---|---|---|---|---|
No schedule date's available now. |
* Prices Inclusive of taxes
Tell us a little about yourself:
This course is designed to teach the students how to prevent SQL performance problems and how to improve the performance of existing SQL.
After completing this course, students will be able to:
This course is for Db2 12 for z/OS application developers, Db2 12 for z/OS DBAs, and anyone else with a responsibility for SQL performance and tuning in a Db2 12 for z/OS environment.
Introduction to SQL performance and tuning
Performance analysis tools
Index basics
Access paths
More on indexes
Tuning methodology and index cost
Index design
Advanced access paths
Multiple table access
Subqueries
Set operations (optional)
Table design (optional)
Working with the optimizer
Locking issues
More locking issues (optional)
Massive batch (optional)