NEUGC - 2022 has ended
Back To Schedule
Wednesday, April 13 • 8:00am - 9:00am
SQL Performance Analysis Tools in ACS

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

Feedback form is now closed.
SQL becomes more and more the standard for accessing data in physical files or SQL tables. Contrary to native I/O where the programmer specifies a physical or logical file that is to be used, in SQL it is the Optimizer who decides whether an index is used or whether the complete table/file is read.
Long running queries are a nuisance. ACS (Access Client Solutions) provide multiple interfaces for recording information about SQL queries and for analyzing the collected data, such as Visual Explain, SQL Plan Cache (Snapshots) or SQL Performance Monitors. All advised indices from both query engines (SQE and CQE) are recorded along with information about how often and when an index was used for the last time. With Access Client Solution this information can be accessed and necessary indexes immediately created. 
Learning Objectives:
                The Access Client Solution (ACS) interface is the easiest way to record and analyze your SQL statements. You’ll get an overview over the different tools such as Visual Explain, SQE Plan Cache and SQL Performance Monitors.
                You’ll learn how to find the long running queries, how to analyze them. Because providing the right indexes is the key for a good SQL performance you’ll also get an introduction into the Index Advisor, Index Evaluator and Index Condenser Interfaces.    
Audience:             Programmers and database administrators/engineers who are faced with problems with long running SQL queries and have to optimize those queries or applications.

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

Wednesday April 13, 2022 8:00am - 9:00am EDT
Grand Centre