Loading…
Attending this event?
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?

Exhibitor Hall: https://www.expocad.com/host/fx/common/s24/exfx.html

Exhibitor Hall Map Here 
Back To Schedule
Wednesday, May 22 • 4:00pm - 5:00pm
393: Visual Explain - IBM's SQL Performance Show-&-Tell

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

Tweet Share
EVALUATION
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.

Learning Objectives:
1. A brief description of optimization with SQL
2. The several ways of invoking Visual Explain
3. The various panes of the Visual Explain window
4. Some features of Visual Explain for managing how it behaves
5. Examples of improved performance after using suggested changes
Speakers
avatar for Vern Hamberg

Vern Hamberg

Senior Software Engineer, Ecolab, Pest Elimination
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 software engineer for the Pest Elimination division at Ecolab. He also serves on the COMMON Americas Advisory Council (CAAC) and SET and is one of the SMEs... Read More →

Wednesday May 22, 2024 4:00pm - 5:00pm CDT
Meeting Room 102 1508 Houston St, Fort Worth, TX 76102
  Database

Attendees (29)