Archives of the TeradataForum

Message Posted: Thu, 09 Jun 2005 @ 19:09:19 GMT

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

<-- Anonymously Posted: Thursday, June 09, 2005 15:12 -->

Currently Optimization is not available when we use 'Variables' in a query.

Optimizer does not know the value of 'Date', it optimizes as if it is a unknown value. Hence you get All Partition Scan. We can expect this optimization soon.

Thanks

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