🎴 Flashcard Mode
NPS (Netezza Performance Server) Database Administration
Card1 / 20
Mastered0
Review0
QuestionClick to flip
In NPS, the max number of columns that can be used for a distribution key?
AnswerClick to flip back
A
4
💡 Explanation:
NPS allows a maximum of 4 columns for a distribution key. Distribution keys determine how data is spread across data slices and are crucial for query performance. Using up to 4 columns gives flexibility for multi-column distribution strategies. Fewer than 4 is allowed, but more is not supported.