title: Static vs dynamic sql
body: <p>In my database at several places developers have used dynamic sql instead of static.   And they are saying reason for this is to improve the performance. Can someone tell me can if dynamic sql can really increase the performance in stored procedure or plsql block? </p>
  
  <p>Which will execute faster and why ?<br>
  1.  </p>
  
  <pre><code>begin  
      execute immediate 'delete from X';  
  end;
  </code></pre>
  
  <p>2.</p>
  
  <pre><code>begin  
      delete from X;  
  end;
  </code></pre>