Using Visual Explain for routines

You can use Visual Explain for routines to view the explained SQL statements as a graph. You can use the information available from the graph to tune your SQL queries for better performance. The nodes in the graph represent tables and indexes and each operation on them. The links between the nodes represent the flow of data.

For detailed information about Visual Explain, refer to Diagramming access plans with Visual Explain.


Feedback