Generate the SQL's Explain Plan
- Let's assume this is the SQL to be checked
SQL To Check
- Adjust the SQL Statement:
- Extract the tested SQL into the Toad SQL editor.
- Replace the COBOL name of each Host Variable with the equivalent database identifier :b<n> where n is a unique number identifying that host variable. If the same variable appears more than one in the SQL use the same database host variable id in all occurrences.
- Force the database to analyze the SQL in Rule Base mode by introducing the RULE database hint phrase.
Adjust the SQL Statement
- Generate the Explain Plan:
- Position the cursor on the SQL area
- Choose the "Explain Plan Current SQL" option on the SQL-Window menu. Alternatively, use CTRL+E.
Get Explain Plan
- The generated plan appears on the result section of the editor.
Explain Plan
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.