Archives of the TeradataForum

Message Posted: Mon, 13 Sep 2010 @ 19:51:54 GMT

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

Hi - First of all you are casting and making the expression go complex - This is the reason for partition read or Dynamic partition elimination not happening.

Moreover Timestamp columns are poor choice for partitioning - they only work for simple timestamp filters with no cast - Even they are poorer choice when it comes to Dynamic partition elimination.

Try to have date columns as partition columns or have a new same column with date datatype.

Thanks-

Sachin

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