It reclaims space from deleted rows and does not re-order data

Enough space is required for GROOM to make a complete copy of the table

GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.

It reclaims space from deleted rows and re-orders data.

An account with NEW USER administrative privilege

An account with CREATE USER administrative privilege.

An account with CREATE GROUP access on the host OS.

An account with CREATE ID access on the host OS.

not Nullable constraint

columns used for filters

distinct values

columns used for joins

table constraints

text-delimited

fixed-length

JSON

HL7

XML

The admin user should be deleted after installing NPS.

The admin user is added to the host OS before installing NPS.

The admin user can not be deleted after installing NPS.

The admin user is the only owner of a database on NPS.

To define load operations in a text file instead of having to specify options on the command line

To ensure that a simple load that uses external tables continues after the system is paused and resumed.

To take advantage of a named pipe capability to stream the data to external tables faster.

To control the re-load operations of me data file after every load failure

DEFAULT

INITIALLY IMMEDIATE

INITIALLY DEFERRED

NULL

DEFERRABLE

nzsql -c " show planfile < planid > "

nzsql -c " select plan_text from _v_plan "

nzsql -c " get planfile < planid > "

nz_get < planid >

nz_plan < planid >