Archives of the TeradataForum

Message Posted: Tue, 05 Jun 2001 @ 13:55:40 GMT

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

Normally between is treated exactly the same as >= and <= as does cause a full table scan unless of course something else in the where clause helps out.

If you put a value ordered index on your date columns then "between" may also use the index.

Thanks, Art Brown

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