Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2005 @ 11:53:52 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Multi Column Statistics Puzzle
From:   Victor Sokovin

  Just to make sure I wasn't losing my mind, I repeated the entire process to validate the confidence levels at each step.  

Thanks for the confirmation. I have come across similar strange things and my working conjecture was that statistics were collected differently (via different parts of the NCR code at least) when SI were present. In other DB that would not be a major discovery as indexes can be quite "independent" of the base tables and one can, for example, analyze them, collect stats on them, etc. However, even NCR staff would tell that in TD the new multi-column stats and the old syntax for index stats would be doing the same thing. I think your example shows once again that it is not the case. Somehow we can produce differences in the explains. Perhaps just different parts of the code are activated on different occasions, and they happen to have different bugs?



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020