Loading…
Attending this event?

Common Europe, in collaboration with FAQ400 (Italy), is delighted to be holding its annual flagship event, Common Europe Congress, in the fashionable city of Milan offering extensive education, networking and relaxation opportunities. It’s also a great opportunity for exploring the city… so why not take a family mini-break as well.

Congress education areas targeted are IBM Power hardware, Application Development, Advanced RPG, Open Source tools and Languages, System Management, Db2 and SQL,  IBM Storage, IBM i services and microservices, Security and Compliance and much more.

There will be two AIX / Linux tracks, to emphasize the Power Systems character of Common Europe.
Top IBM Business Architects and industry experts have already agreed to share their knowledge on the latest announcements, customer cases as well as practical subjects.

REGISTRATION CAN BE FOUND HERE

Wednesday, June 5 • 16:40 - 17:40
SQL Performance Analysis Tools in Access Client Solutions (ACS)

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
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.
Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, 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 June 5, 2024 16:40 - 17:40 CEST
Asia B
  IBM i
Feedback form isn't open yet.

Attendees (11)