Archives of the TeradataForum

Message Posted: Thu, 17 Jul 2003 @ 09:25:47 GMT

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

Use of between should be encouraged all round whenever dates are being looked at. This tells the optimizer that there is a range check and as you state, will generally choose the optimized route you where after.

Cheers

Andy

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