Loading…
LUG 78
Attending this event?
Welcome to Rochester and the 78th LUG meeting - celebrating 25 years!
Friday, September 20 • 8:30am - 9:45am
Using ACS Visual Explain to understand query performance/Linda M Swan

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

Linda will provide an explanation of how to use Visual Explain (VE) to understand query performance. Understanding why the optimizer chose the given plan is not always crystal clear but with a little effort in understanding the VE at hand you can often discover where the optimizer can use a little help. This session will include several of the most commonly confronted problems seen by the development lab from a field support perspective. Whether your problem query is caused by inefficient use of indexes, poor join order, outdated statistics, missing indexes, a poorly formed question of the data or some other reason, you can use Visual Explain in IBM i Access Client Solutions to gain the needed insight to move forward.

Friday September 20, 2019 8:30am - 9:45am
025-2 E105 (Main Tent)