0 votes
in Netezza by
Why NOT NULL specification is better in Netezza?

1 Answer

0 votes
by

Specifying not null results in better performance as NULL values are tracked 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.

Related questions

0 votes
asked Feb 19, 2023 in Netezza by rajeshsharma
0 votes
asked Feb 21, 2023 in Netezza by Robindeniel
...