Archives of the TeradataForum
Message Posted: Tue, 05 Jun 2001 @ 13:55:40 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|