Archives of the TeradataForum

Message Posted: Fri, 11 Feb 2005 @ 21:23:26 GMT

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

So queries, where the optimizer is takeing advantage of the partition have to have always a format like

     select ....
     from ....
     where store_number * 1000 + product_code between ... and ...

or similar ...

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