Chat now with support
Chat with Support

Toad for Oracle 12.11 - Getting Started Guide

Table of Contents Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Generate Explain Plans

Work with Code

Toad provides an intuitive and efficient way to write, run, and test your SQL and PL/SQL code. Toad supports efficient code management for a single developer or a whole team of developers.

 

Generate Explain Plans

Tip: Click . to edit the display options, such as the sorting order and alignment.

Save Explain Plans

Work with Code > Optimize SQL > Generate Explain Plans > Save Explain Plans

You can save explain plans automatically in Toad or manually save them as an external file. The first option allows you to compare a current or historic Explain Plan to the saved file in the future.

To save Explain Plans automatically

  1. Select View | Toad Options | Oracle | General.
  2. Select Save previous Explain Plan results.

To save Explain Plans to an external file

  1. Run an Explain Plan.
  2. Right-click the plan and select Save to XML file or Save image.

    Note: To open an XML explain plan, right-click the Explain Plan area and select Load plan from XML.

 

Customize your Toad Environment

Customize the Toad Interface

Toad provides many ways for you to customize the interface to suit your work style and improve your productivity. Most areas of the interface are customizable, from the toolbars and menus, to the grids and workspace itself. You can also set custom defaults for actions, commands, and other tasks that Toad performs for you.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating