0 votes
in Netezza by
Can we update all columns in a Netezza table?

1 Answer

0 votes
by

No, the column that is used in the distribution clause cannot be used for updates. Remember, up to four columns can be used for the distribution of data on SPU. From a practical sense, updating distribution columns result in the redistribution of data; the single most performance hit when a large table is involved. This restriction makes sense.

...