Loading…
Unlock the Power of IBM i at POWERUp 2025!

Join us in Disneyland, California, for POWERUp 2025, the premier conference for IBM i professionals. Whether you’re an experienced expert or just starting your IBM i journey, this event offers unparalleled education, hands-on workshops, and valuable networking opportunities. Stay ahead of the curve with insights from industry leaders, explore the latest innovations, and connect with a thriving community that shares your passion for IBM i. Don’t miss this opportunity to expand your knowledge, grow your skills, and power up your career!
← Back to schedule
Visual Explain - IBM's SQL Performance Show-&-Tell
Thursday May 22, 2025 3:00pm - 4:00pm PDT
Room 10
For many years now IBM have positioned SQL as the primary interface to the database on IBM i. At the same time, new capabilities are being added only to SQL, not to the native database interface.

We need a different tool to understand and analyze query implementation plans and feedback from the optimizer – the SQL component that determines the most effective way to deliver the data we ask for in SQL statements. Visual Explain is just such a tool, and it both shows us graphically what plan the optimizer has chosen, as well as tells us details about each step along the way. It can also give us suggestions on ways to improve performance of our queries.
Speakers
avatar for Vern Hamberg

Vern Hamberg

Senior iSeries Developer, OneMain Financial
Vern has worked on IBM midrange systems for over 30 years, beginning with the System/38 and AS/400. At present he is a Senior iSeries Developer at OneMain Financial. He serves on the COMMON Strategic Education Team (SET), is one of the SMEs for Db2, and has served on the COMMON Americas... Read More →
Thursday May 22, 2025 3:00pm - 4:00pm PDT
Room 10 1150 Magic Way, Anaheim, CA 92802
  Database

Attendees (1)


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

Tweet Share
Share Modal

Share this link via

Or copy link