Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 13 Sep 2002 @ 20:00:11 GMT

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

Subj:   Re: Decimal or time in PI
From:   Geoffrey Rommel

  Also, there was a discussion on 'time is bad for PI'? True? What was the reason?  

  Because you need the exact value to be able to use the PI and you probably don't know the exact time up to the second/millisecond.  

And also because in some installations TIME fields were not being hashed properly: all values hashed to the same AMP. This has been corrected in more recent releases. We do have a few tables that are hashed by timestamp(0), but they are used mostly for logging and reporting, not for searches by PI.


  <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