InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Why Not Null Specification Is Better In Netezza? |
|
Answer» Specifying not NULL RESULTS in better PERFORMANCE as NULL VALUES are tracked at rowheader level. Having NULL values results in STORING references to NULL values in header. If all columns are NOT NULL, then there is no record header. Specifying not null results in better performance as NULL values are tracked at rowheader level. Having NULL values results in storing references to NULL values in header. If all columns are NOT NULL, then there is no record header. |
|