Loading…
Tuesday, June 19 • 08:00 - 09:00
Performance Optimization of your SQL Statements

Sign up or log in to save this to your schedule and see who's attending!

Feedback form is now closed.
Agenda: 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 Query Optimizer who decides whether an index is used or whether the complete table/file is read. Long running queries are a nuisance, but what is the reason why an SQL statement performs badly? Is there a way to affect the query optimizers decisions?Before using any analysis tool, it is important to know what steps must be performed when executing a SQL statement. How work the query optimizer and the statistics manager together? What is the difference between a full and pseudo open? "¦ and much more. Visual Explain is the core of the analysis tools provided in Access Client Solutions (ACS), it provides information about a single SQL statement. Visual Explain is at first the graphical representation of the access plan, but includes a lot of detailed information about the SQL statement, such as about the advised indexes or which is most time consuming step. Learning Objectives:Before using Visual Explain, you"ll learn several details about the Query Optimizer, about the Statistics Manager and how you can affect the query optimizer"s decisions.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Engineer, Toolmaker Advanced Efficiency GmbH
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Tuesday June 19, 2018 08:00 - 09:00
Orchidea A

Attendees (10)