Name: C12 | Efficiently Finding and Fixing High Resource Consuming SQL
Start: 2026-10-28T14:00:00-0400
End: 2026-10-28T15:00:00-0400

C12 | Efficiently Finding and Fixing High Resource Consuming SQL

Wednesday October 28, 2026 2:00pm - 3:00pm EDT

Magnificent 4

This presentation will demonstrate how to find, analyze and tune the top 40 expensive queries. Special emphasis will be on finding the cursors that could benefit from multi-row fetch. In addition, discussions on designing perfect indexes, MQTs and AQTs, along with manual query rewrite, SQL exploitation and most important, proper use.

Speakers

Sheryl Larsen

President, Sheryl M Larsen LLC

Sheryl Larsen is an internationally recognized researcher, consultant and lecturer, specializing in DB2 and is known for her extensive expertise in SQL. Sheryl has over 30 years’ experience in DB2, has published many articles, several popular DB2 posters, and co-authored a book... Read More →

Wednesday October 28, 2026 2:00pm - 3:00pm EDT
Magnificent 4

Track C, Technical Session

Audience All
Subject z/OS
Area AppDev, Back to Basics, Best Practices, Latest and Features z/OS, Modernization in Development, User Stories, Working with SQL

IDUG NA 2026

Sheryl Larsen

Get help with the event

IDUG NA 2026

Sheryl Larsen

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Get help with the event