How to read Oracle execution plan

How to view the oracle execution plan

There are many ways to view the execution plan, as follows:

1. Open a familiar viewing tool: PL/SQL Developer.

After writing a piece of SQL code in PL/SQL Developer, press F5, PL/SQL Developer will automatically open the execution plan window and display the execution plan of the SQL.

2. Explain plan for command

in the command window opened by sql*plus or PL/SQL Developer , execute the following command:

1) explain plan for select * from dual; Enter

2) select * from table(dbms_xplan.display); Enter

php Chinese website, a large number of PHP tutorials and related programming tutorials, welcome to learn.​

The above is the detailed content of How to read Oracle execution plan. For more information, please follow other related articles on the PHP Chinese website!