title: In Oracle SQL, can I query a partition of a table instead of an entire table to make it run faster?
body: <p>I would like to query a table with a million records for customers named 'FooBar' that have records dated on 7-24-2016.  The table has 10 days of data in it.</p>
  
  <pre><code>select * 
  from table
  where customer = 'FooBar'
  and insert_date between to_date('2016-07-24 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and to_date('2016-07-24 23:59:59', 'YYYY-MM-DD HH24:MI:SS');
  </code></pre>
  
  <p>The problem with the query above is that it takes awhile to run.  I would like it to run faster.</p>
  
  <p>The table is partitioned into 24 hr days.  Could I focus the query on the table partitions?  Would that make the query run faster? </p>
  
  <pre><code>select *
  from partition-7-24-2016
  where customer = 'FooBar'; 
  </code></pre>