Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: TeraData's optimizer
From:   Arthur Brown

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020