Tag: databases

In NPS the minimum NPS row overhead is how many bytes

In NPS, it's a best practice to use 'rowid' as a primary key in a database table to guarantee quick access

In NPS, the max number of columns that can be used for a distribution key?

In NPS, 'ALTER TABLE customer ADD COLUMN (newcol char(10))' will add a new column to the table

In NPS, 'ALTER TABLE customer ADD COLUMN (newcol char(10))' will add a new column to the table

In NPS, boolean data types make good distribution keys

In NPS, by default, what is used to signal the end of a line or SQL command within an nzsql session?