0 votes
in Netezza by
How the NOT NULL specification on a column improves the Netezza performance?

1 Answer

0 votes
by

Specifying Not Null on each column in the table results in better performance. Netezza tracks the NULL values at row header level. Having NULL values results in storing references to NULL values in the header. If all columns are NOT NULL, then there is no record header.

...