Examining Explain Plans
TOAD allows you to easily see the explain plan for the currently executed SQL statement. This is visualized on the Explain Plan tab in the results panel. Figure 3.41 illustrates a rather simple explain plan.
Figure 3.41. TOAD explain plans.
 | Ctrl+E also runs and displays an explain plan. |
 | It is beyond the scope of this book to provide a basic explanation of explain plans and the various features of the rule- and cost-based ... |
Get TOAD® Handbook 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.
