Re: How to move partition files

[Adrian Chapela Cordeiro]

Yes, I am thinking about your option.

I select the data with the key of the partition but the key will be a datetime field.

I need to do:

Select * from table where date_field > 'datetime value' AND date_field < 'datetime value'.

With this I will have partition pruning but I will be selecting three partition in the pruning. Example:

p20081001 -> partition having 01-10-2008 date rows
p20081002 -> partition having 02-10-2008 date rows
p20081003 -> partition having 03-10-2008 date rows

I will perform this query to select 02-10-2008 data.

select * from table where date_field > '2008-10-01 23:59:59' AND date_field < '2008-10-03 00:00:01'

Partition pruning will select three partitions but the data will be only from one partition, p20081002.

I am thinking about the fastest process!