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? Get an overview of SQL performance concepts and look at some of the no-charge tools to help you tune applications without the need to become an SQL performance guru. Learn the difference between CQE and SQE and why it matters. Get expert advice on the number of indexes/logicals you should have, including how many is too many. Find out the difference between using an LF name in your SQL statements versus a PF or table name. Leave this session with an understanding of which tools can tell you how to improve the performance of a specific SQL statement or program.
Sign in to add slides, notes or videos to this session