16.11. Using Visual Explain to Examine Access Plans
Once the EXPLAIN data has been stored in the explain tables, it can be queried or displayed using Visual Explain or other explain tools. This section describes how to use the Visual Explain tool to review and analyze an access plan.
Visual Explain is a graphical utility that gives the database administrator or application developer the ability to examine the access plan determined by the optimizer. Visual Explain can only be used with access plans explained using the snapshot option.
You can use Visual Explain to analyze previously generated explain snapshots or to gather explain data and explain dynamic SQL statements. If the explain tables have not been created when you start Visual Explain, ...
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
