Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 18 Jul 1999 @ 16:35:26 GMT


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


Subj:   Hash buckets
 
From:   Walt Craig

Are there 64K hash buckets in the entire system, or 64K on each AMP. Either way how can 64K buckets support tables with billions of rows. Logic tells me that even with the 16 bit value for uniqueness, tables with multi-billions of rows would encounter incredible numbers of hash collisions, causing severe performance problems.

This is really a philosophical question, because somehow it seems to work. I just don't understand how and I don't have an answer when people ask me about it.


Walt Craig
Forelyn Associates, Inc.



     
  <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: 27 Dec 2016