InterviewSolution
| 1. |
Can You See Execution Plan Of A Statement? |
|
Answer» YES. In many WAYS, for example from GUI based tools like TOAD, Oracle SQL Developer. Configuring AUTOTRACE, a SQL*Plus facility AUTOTRACE is a facility within SQL*Plus to show us the explain plan of the queries we've executed, and the RESOURCES they USED. Once the PLAN_TABLE has been installed in the database, You can control the report by setting the AUTOTRACE system variable.
YES. In many ways, for example from GUI based tools like TOAD, Oracle SQL Developer. Configuring AUTOTRACE, a SQL*Plus facility AUTOTRACE is a facility within SQL*Plus to show us the explain plan of the queries we've executed, and the resources they used. Once the PLAN_TABLE has been installed in the database, You can control the report by setting the AUTOTRACE system variable. |
|