title: How do I view the Explain Plan in Oracle Sql developer?
body: <p>I have few SQL queries which has very low query running performance and I want to check the query execution plan for this query. I am trying to execute the below query but its not showing any query execution plan. Its only display message plan FOR succeeded. I dont know is there any settings that we have to do in oracle sql developer to vies explain plan for query :</p>
  
  <pre><code>EXPLAIN PLAN FOR 
  Select SO.P_OPTION_ID FROM
  SIMSIM 
     JOIN P_TYPE PT on PT.KEY=SIM.P_TYPE_KEY JOIN P_CONFIG PC ON PC.ID=PT.PRODUCT_CONFIG_ID
  JOIN P_OPTION PO ON PO.OPTION_KEY=PC.DEFAULT_PRODUCT_OPTIONS JOIN S_OPTION SO ON SO.SERVICE_ID=SIM.ASSIGNED_TO_SERVICE_ID
  JOIN AVV_NO AN ON SIM.ASSIGNED_ANUMBER_ID = AN.ID
   where SO.STATUS_ID IN (20,40) 
   and SO.ID &lt; to_char(SYSDATE - numtodsinterval (  1,'MINUTE' ), 'YYYYMMDDHH24MISS')||'0000'
   and SO.ID &gt; to_char(SYSDATE - numtodsinterval (  1, 'HOUR' ), 'YYYYMMDDHH24MISS')||'0000'
  and NOT EXISTS(SELECT ID from TEMP_BPL T WHERE T.ID = SO.ID );
  </code></pre>