In Oracle SQL, can I query a partition of a table instead of an entire table to make it run faster?
<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>