|
|
Archives of the TeradataForum
Message 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
| |