Archives of the TeradataForum

Message Posted: Fri, 13 Oct 2006 @ 19:11:34 GMT

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

Hi Ray,

Yes, It does use PPI as the Explain says.

When values are supplied from a data file, It is as good as supplying a constant in the query expect that the constant is coming from a data file. The constant is read in from the data file & substituted for the variable before the query is processed. So the optimizer knows the value for sure & it does use PPI & partition elimination.

Regards,

Sanjaya

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