title: Is substr or LIKE faster in Oracle?
body: <p>Would </p>
  
  <pre><code>WHERE substr(my_field,1,6) = 'search'
  </code></pre>
  
  <p>or </p>
  
  <pre><code>WHERE my_field LIKE 'search%'
  </code></pre>
  
  <p>be faster in Oracle, or would there be no difference?</p>