title: Oracle Multiple Overlapping Between Statements
body: <p>Will Oracle flatten multiple between clauses if they have overlapping data?  In my application, users can create dynamic search terms, so it's possible that there could be overlapping data.  Will Oracle optimize the SQL for me or do I have to calculate it before I create the SQL?</p>
  
  <p>i.e.</p>
  
  <p>Select id from xxtable WHERE id (BETWEEN 10 AND 20) or (BETWEEN 18 AND 30)</p>
  
  <p>Will it be run "as is" or converted to:</p>
  
  <p>Select id from xxtable WHERE id (BETWEEN 10 AND 30)</p>
  
  <p>Thanks for your time.</p>