Toad Data Studio 1.1

Chat now with support

Create Amazon Redshift Connections Create ODBC Connections Create Oracle Connections Create Snowflake Connections Create SQL Server Connections Create SharePoint Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Generate Explain Plans

The explain plan displays the steps a database uses to execute an SQL statement. The results of the plan display the order a database uses to search/join tables, the types of access used (indexed search or full table scan), and the names of indexes used. If you are using cost-based optimization, this statement also determines the cost of executing the statement. You can use explain plans to help tune SQL to improve performance.

Toad automatically generates an estimated explain plan when you select the Explain Plan tab in the Results pane.

Tip: If you occasionally closed the Results pane, you can restore it by selecting Editor | Windows | Script Results.

For SQL Server and Oracle, the following explain plans are available:

Estimated plan—Plan that is generated by executing the RDBS execution plan commands. This plan does not execute the query.
Actual plan—Plan that was used to execute the SQL.

Note: For Oracle, the explain plan is retrieved from the V_$SQL_Plan view. You must have proper privileges for V_$SQLAREA and V_$SQL_PLAN to generate an actual explain plan.

To generate an estimated explain plan

Click in the Editor toolbar.

To generate an actual explain plan

Click in the Editor toolbar.
Execute the statement and select the Explain Plan tab.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Toad Data Studio 1.1 - User Guide

Generate Explain Plans