Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 08 May 2002 @ 13:28:42 GMT


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


Subj:   Re: Value Order Indexes
 
From:   Ruth Fenwick

Tony,

I find the optimizer is very sensitive to new values in an index, especially date fields. With a value ordered index, the optimizer KNOWs the highest value, when you add another day, and don't tell it, it assumes that there is no value for that day and it would return no rows for that part of the query.....choosing what is obviously a bad path....

To avoid this very problem, I actually collect stats on all my date fields (columns and indexes) every night. Adds a bit to the batch schedule, but pays off the next day with the on-lines.

Ruth Fenwick
IA&DSS Team Leader, IRM
Hudson's Bay Company



     
  <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: 15 Jun 2023