Chatta subito con l'assistenza
Chat con il supporto

Toad for SAP Solutions 4.2 - Installation Guide

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.

In order to determine the cost of execution of a statement on SAP ASE you need to enable resource limits. Use enable sp_configure "allow resource limits", 1 and restart your database.

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.

To generate an estimated explain plan

  • Click in the Editor toolbar.

  

Related Topics

View Result Sets 

View Execution Log Messages 

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione