com Identificações: redistribute X
DeepashriKrishnaraja Identificações: collocated key netezza distribution slice skew unique redistribute ampp data distribute random performance join response hash time 4.274 Visitas
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. ...Modificado por 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...
do Blog: Thoughts from Support