InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Can We Update All Columns In A Netezza Table.? |
|
Answer» No, the column that is USED in distribution clause cannot be used for UPDATES. Remember, up to four columns can be used for distribution of data on SPU. From practical sense, updating distribution columns RESULT in redistribution of data; the single most PERFORMANCE hit when large table is involved. This restriction makes sense. No, the column that is used in distribution clause cannot be used for updates. Remember, up to four columns can be used for distribution of data on SPU. From practical sense, updating distribution columns result in redistribution of data; the single most performance hit when large table is involved. This restriction makes sense. |
|