Use the Explain Plan tool to analyze the execution of a single SQL statement. By examining the execution plan, you can see exactly how Oracle executes your SQL statement, and how it can be improved.
This tool lets you:
|
TIP: The Analyze Tool can be used in conjunction with the Explain Plan tool. The Explain Plan Tool does not analyze tables itself prior to executing the Explain Plan, but it does have a toolbar button for manual launch of the Analyze Tool. |
Generate Plans |
Drag a SQL Statement into the editor on this tab.
| ||||||||||||||||
Browse Saved Plans | Browse previously saved execution plans. | ||||||||||||||||
Operation Description |
Explain the node selected in the Explain Plan tree. Show how each SQL operation is executed in relation in the Explain Plan. Show / Hide in Generate Plans | Show Description. | ||||||||||||||||
Plan | The generated execution plan. Click on nodes to expand and collapse them. |
Use File | Print.
The following data is printed:
|
TIP:
|
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center