Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Aug 2010 @ 18:24:40 GMT


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


Subj:   Re: No Primary Index (NoPI) Table in TD 13
 
From:   Diehl, Robert

Dave,

Definition of a small table depends on the system size.

I don't remember the way to determine this off the top of my head. I don't have time to look it up right now.

Table would definitely be small if it can fit into memory.

Table would be small if the number of rows is less than the number of amps. You will by default get skew if the number of rows less than the number of amps on the system.

No way to evenly put 100 rows across 1000 amps. At least 900 amps would have zero rows.


Thanks,

Robert Diehl
Travelocity Data Warehouse DBA



     
  <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