title: Oracle Query Date Range
body: <p>This query takes 16 minutes. Is there a faster way?</p>
  
  <pre><code>select INIT.MPI_MEMHEAD.MEMIDNUM 
  from INIT.MPI_MEMHEAD 
  inner join INIT.MPI_AUDHEAD 
  on INIT.MPI_AUDHEAD.audrecno = INIT.MPI_MEMHEAD.CAUDRECNO 
  where(INIT.MPI_AUDHEAD.audctime+0)  &gt;= to_date('01-JAN-14') AND (INIT.MPI_AUDHEAD.audctime+0) &lt;=  to_date('01-APR-14')
  </code></pre>