How do you know if you're getting the best performance from your embedded SQL RPG programs? The SQL engine and its optimization capabilities are always evolving so even if you did a good job of optimizing your programs originally, how do you know if they are still performing as well as they could?
In this session, Susan provides an overview of SQL performance concepts and looks at some of the no-charge tools to help you tune applications without the need to become an SQL performance guru.
Some of the questions we'll address include:
- What's the difference between CQE and SQE and why do I care?
- Should I worry about the number of Indexes/logicals I have? How many is too many?
- Does it make a difference if I use a LF name in my SQL statements vs a PF or table name?
|
Susan Gantner
