Archives of the TeradataForum

Message Posted: Tue, 18 Dec 2012 @ 09:43:24 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Tuesday, December 18, 2012 04:29 -->

Dear Experts,

I have a table with many advanced [around more than 400] empty paritions on DATE_fld column. But when i give the condition 'DATE_fld >DATE' [current date], its obvious it will scan all post partitions after the date given. [My PPI is on DAY basis]

But is there any performance issues when the query scans a lots of empty partitions ?

I know that it might sometimes will mislead for making suboptimal plan choices. But still want other thoughts...

	<Prev	Next>		<<First	<Prev	Next>	Last>>