Archives of the TeradataForum

Message Posted: Sat, 26 Nov 2011 @ 09:07:14 GMT


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

Subj:		Re: Performance issue due to too many partitions

From:		Machha Narayan Rao Naidu

rishi.agarwal wrote:

I don't think there will be any performance issue if the data is not available in all the partitions. This is how PPI is creating as we cannot modify the table structure every time to change the range of PPI.

Hi,

Thats how Partition works, each partition is a virtual table thus no of partition will not affect but need to make sure not much data goes to UNKNOWN Partition.

Thanks

Machha