Archives of the TeradataForum

Message Posted: Tue, 12 May 2009 @ 10:37:13 GMT

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

PPIs were mainly designed to suite/enhance range(BETWEEN clause) kind of queries. So if such queries are often used with a table and the column which are used to specify the range are different from that of the PI then you could go in for PPI with the range specifying column participating in defining the partitioning expression.

KSN.

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