|  |  | Archives of the TeradataForumMessage Posted: Thu, 07 Feb 2008 @ 09:26:15 GMT
 
 
  
| Subj: |  | Re: Dealing with concentrated values in the data |  |  |  | From: |  | Dieter Noeth |  
 Christian Schiefer wrote: 
 
 |  | This is 10% meaning 10% skew, which is also not "too" bad.  For a FTS this means a 10% penalty vs. a perfectly distributed table. I don't
know the size of your system, but 10% of ( 10M rows x 127 Bytes ) = 127MB "additional" work for 1 AMP does also look not too bad. |  | 
 
 
 10% skew? On a 100 AMP system there should be about 1% on each AMP, but 10% is 10 times as much. 
 Dieter 
 
 |  |