Netezza Internal DataTypes: rowid, createxid, deletexid and datasliceid

Netezza supports internal datatypes that are used by system to perform internal tasks on the table records. Netezza internal datatypes includes: rowid, transaction ID (createxid, deletexid), and dataslice. Shows Netezza internal Datatypes: Internal Datatype Column Name rowid rowid transaction ID Createxid deletexid dataslice datasliceid Netezza Internal DataTypes: Rowid Identifies a specific and unique record in the database. These row numbers are not necessarily sequential within a table. Usually, the initial rowid value is 100,000. The Netezza host assigns a range of sequential rowids to each SPU in the system. When…

Continue ReadingNetezza Internal DataTypes: rowid, createxid, deletexid and datasliceid
Comments Off on Netezza Internal DataTypes: rowid, createxid, deletexid and datasliceid

Working with Netezza Clustered Base Tables (CBT)

A Netezza clustered base tables (CBT) are user table that has data which is organized using one to four organizing keys columns. You can specify max four columns in organize on clause and those columns should not be a part of distribute on clause. An organizing key is a column of the table that you specify for clustering the table records; organizing table helps Netezza to save records in same or nearby extents. You can organize the records using "ORGANIZE ON" clause. Netezza does create zone maps on organizing columns, which will accelerate the performance of queries on that…

Continue ReadingWorking with Netezza Clustered Base Tables (CBT)
Comments Off on Working with Netezza Clustered Base Tables (CBT)