Archives of the TeradataForum

Message Posted: Thu, 19 Nov 2009 @ 15:20:30 GMT


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

Subj:		Re: Partition elimination with CAST INTEGER AS DATE

From:		Anomy Anom

<-- Anonymously Posted: Thursday, November 19, 2009 10:16 -->

Did you COLLECT STATS on system-generated "column" PARTITION? If not, range expressions often tend to scan all partitions.


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

Archives

2009 Indexes

Last Modified: 15 Jun 2023