When evaluating a plan, examine the statement’s actual resource consumption. If you are using SQL*Plus then use DBMS_XPLAN.įurthermore How do you analyze an Oracle plan? It is best to use EXPLAIN PLAN to determine an access plan, and then later prove that it is the optimal plan through testing. It will be then displayed in the Explain Plan window. Press F10 or click the Explain Plan icon. In SQL Developer, you don’t have to use EXPLAIN PLAN FOR statement. Secondly, How do I run a Explain plan in SQL Developer? Ctrl+E also runs and displays an explain plan. Figure 3.41 illustrates a rather simple explain plan. This is visualized on the Explain Plan tab in the results panel. TOAD allows you to easily see the explain plan for the currently executed SQL statement.
If you want an upgrade/install from Quest for any Quest product, you need 3 things: A license for the product (in this case Toad for Oracle) To be current on your maintenance contract (automatically included for 1 year at time of purchase)Īlso, How do I check my query plan in Toad?
0 kommentar(er)
