ROWID and others in Netezza

Posted: September 21, 2014 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.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s