with Tags: redistribute X
DeepashriKrishnaraja Tags: collocated key netezza distribution slice skew redistribute unique ampp data distribute random performance join response hash time 3,983 Visits
Performance, thy name is Netezza. One of the key factors which contribute to this aspect is the intelligent data distribution owing to the AMPP architecture of Netezza. This efficient data distribution is determined by a good distribution key. ...
from Blog: IBM PureData-Netezza Developer Network (NDN)Modified by DeepashriKrishnaraja
While running redistribute in a DPF environment, the following suggestions may help improve redistribute performance Starting DB2 V9.5 FP1 and V9.7 GA, the "NOT ROLLFORWARD RECOVERABLE" parameter was introduced. With this option logging is minimal...
from Blog: Thoughts from Support