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.
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');
where customer = 'FooBar';
The correct syntax is
select [columns] from [table] partition ([partition]). So, in this usecase, you'd have something like this:
SELECT * FROM mytable PARTITION (partition_7_24_2016) WHERE customer = 'FooBar';