Archives of the TeradataForum

Message Posted: Fri, 27 May 2011 @ 09:40:20 GMT

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

Hi All,

If I have partitioning enable for a column and I am using string function for that column in my query then will optimizer still use partitioning.

If I have stats collected for a column and I am using string function(say cast or extract etc.) for that column will optimizer still use stats.

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