Best way to have Partition "Pruned storages" on a query

eli_revach

Hi ,

My partition key on the table is Year Mont WeekInAMonth something like 
20130902 ,Partition expresion on the create table is   - > PARTITION BY DATE_PART('year', bpm_application_performance_1.timestamp_utc)* 100+ date_part('month', bpm_application_performance_1.timestamp_utc)*10+ CEILING(DATE_PART('day',bpm_application_performance_1.timestamp_utc)/ 7) 

I find Vertica  able to Pruned the partition only after i put the same experation of the PARTITION BY  in my query (only after i add this to the query -> and      DATE_PART('year', bpm_application_performance.timestamp_utc)* 100+ date_part('month', bpm_application_performance.timestamp_utc)*10+ CEILING(DATE_PART('day',bpm_application_performance.timestamp_utc)/ 7)     >=DATE_PART('year', to_timestamp(1378067838))* 100+ date_part('month', to_timestamp(1378067838))*10+ CEILING(DATE_PART('day',to_timestamp(1378067838))/ 7)      and  DATE_PART('year', bpm_application_performance.timestamp_utc)* 100+ date_part('month', bpm_application_performance.timestamp_utc)*10+ CEILING(DATE_PART('day',bpm_application_performance.timestamp_utc)/ 7) <=      DATE_PART('year', to_timestamp(1378067838+3600))* 100+ date_part('month', to_timestamp(1378067838+3600))*10+ CEILING(DATE_PART('day',to_timestamp(1378067838+3600))/ 7)

Are this is the only way to have  pruning  for such partition key ?  looking in the explain plan its looks like it required extra resources !

Thanks