Sunday, September 21, 2014

ROWID and others in Netezza


ROWID – unique value assigned by the hashing process in order to distribute the row to the proper SPU.
DATASLICEID – unique value number assigned to every SPU.
CREATEXID – identification for the transaction that created the row.
DELETEXID – identification for the transaction that deleted the row. This value is zero for active rows.

No comments :