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.

Related concepts
Creating stored procedures
Creating user-defined functions (UDFs)
Related tasks
Developing database routines
Related information
Analyzing SQL statements with Visual Explain

Feedback