List or filter explainable SQL statements from multiple plans and packages. DB2 Visual Explain lets you include many plans and packages in one filter definition to save time. Filter explainable SQL statements. You can filter statements from multiple plans and packages by using cost and access path criteria and table and index references. You can save filter settings to reuse or modify later.
Filter explain table rows.
You can limit the rows from the plan table, statement table or function table by filtering on multiple criteria. Specify your own qualifier for catalog tables. You can avoid using your DB2 catalog for DB2 Visual Explain queries by copying the catalog tables. Then you can specify your own qualifier to access the copied tables when DB2 Visual Explain retrieves DB2 catalog information. Specify your own qualifier for explain tables.