How do I view the Explain Plan in Oracle Sql developer?
EXPLAIN PLAN FOR In SQL Developer, you don’t have to use EXPLAIN PLAN FOR statement. Press F10 or click the Explain Plan icon. It will be then displayed in the Explain Plan window. If you are using SQL*Plus then use DBMS_XPLAN. For example, See How to create and display Explain Plan