Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 13 Dec 2003 @ 12:29:58 GMT


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


Subj:   Re: Collect Stats on Single Column SI
 
From:   Victor Sokovin

John,

Thank you for the details so far. My understanding was that index stats should somehow be reflecting the physical implementation of the index, which may vary depending on the options used with index creation. I am referring here to things like ORDERED BY VALUES or ORDERED BY HASH etc. Or, is the optimizer guided only by the column stats plus some hard coded rules which would tell it to, say, use the 'ORDERED BY VALUES' index and ignore the 'ORDERED BY HASH' one, no matter what the current situation with the index itself is (like in the index validation procedure)?


Regards,

Victor



     
  <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: 23 Jun 2019