The execution plan shows the steps that the database takes when it executes an SQL query. By experimenting with diferent options and analyzing the changes in SQL execution plan, you can tune your SQL for better performance.
First you need to create a PLAN_TABLE by executing the utlxplan.sql:
@$ORACLE_HOME/rdbms/admin/utlxplan.sql
One easy option is to use the SET AUTOTRACE command in SQL*Plus to enable automatic execution plan dislplay in SQL*Plus.
Add A Comment
You must be logged in to post a comment.