IBM CV964G - Db2 12 for z/OS SQL Performance and Tuning - Seminar / Kurs von Cegos_Integrata GmbH
Inhalte
- Understand and design better indexes
- Determine how to work with the optimizer (avoid pitfalls, provide guidence)
- Optimize multi-table access
- Work with subqueries
- Avoid locking problems
- Use accounting traces and other tools to locate performance problems in existing SQL
- and more
presentation, discussion, hands-on exercises
Lernziele
Overview
This course is designed to teach the students how to prevent SQL performance problems and how to improve the performance of existing SQL.
Zielgruppen
Audience
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.
Termine und Orte
| Datum | Uhrzeit | Dauer | Preis | ||
|---|---|---|---|---|---|
| Leinfelden-Echterdingen, DE | |||||
| 13.08.2024 - 15.08.2024 | 10:00 - 17:00 Uhr | 1 h | Mehr Informationen > | Jetzt buchen › | |