![]() Tip: If you occasionally closed the Results pane, you can restore it by selecting Editor | Windows | Script Results.įor SQL Server, the following explain plans are available: Toad automatically generates an estimated explain plan when you select the Explain Plan tab in the Results pane. ![]() You can use explain plans to help tune SQL to improve performance. If you are using cost-based optimization, this statement also determines the cost of executing the 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. The explain plan displays the steps a database uses to execute an SQL statement. You are here: Edit SQL > Execute SQL and View Results > Generate Explain Plans Generate Explain Plans
0 Comments
Leave a Reply. |