Netezza Generate Statistics

Reading Time: 4 minutes

Netezza uses the cost based optimizer to determine best methods determine redistribution, scan, join, join orders. Netezza query optimizer relies on the statistics from catalog to come up with an optimal query execution plan. So it is imperative that the statics need to be kept current without which the execution plan generated by the optimizer may be sub-optimal resulting… Continue reading Netezza Generate Statistics

Published
Categorized as learn Tagged

Connect Netezza to Python using JDBC Driver

Reading Time: 3 minutes

Connect to Netezza by using various methods and programming languages. Netezza supports ODBC, OLEDB and JDBC drivers for connections. Before you begin Before you begin, gather this connection information from the database administrator: Name of the server that hosts the database you want to connect to Database name User name and password Are you connecting… Continue reading Connect Netezza to Python using JDBC Driver

Published
Categorized as learn Tagged

Netezza Sequence – Creation and retrieval

Reading Time: 5 minutes

A Netezza sequence can provide unique values when the getnext value method. You can use the sequence to generate unique numbers that can be used as surrogate key values for primary key columns. What to read next? Nothing to see here. Consider joining one of our full courses..

Published
Categorized as learn Tagged

Materialized Views in Netezza

Reading Time: 5 minutes

Materialized View is a sorted projection of one and only one table MVs reduce the width of the data being scanned by creating a thin version of the table–based on frequently queried columns. This selection of frequently queried columns is called projection. MVs are typically sorted like the base tables, but can be ordered on… Continue reading Materialized Views in Netezza

Published
Categorized as learn Tagged

Netezza Failover Architecture

Reading Time: 2 minutes

As an appliance Netezza includes necessary failover components to function seamlessly in the event of any hardware issues so that its availability is more than 99.99%. There are two hosts in a cluster in all the Netezza appliances so that if one fails the other one can takes over. Netezza uses Linux-HA (High Availability) and… Continue reading Netezza Failover Architecture

Published
Categorized as learn Tagged

Netezza Transactions BEGIN, COMMIT, ROLLBACK

Reading Time: 2 minutes

Netezza  transactions can be summarized using the following : Transactions start with BEGIN WORK. Transactions are validated with COMMIT WORK. Transactions are canceled with ROLLBACK WORK. Statements executed outside of a transaction are automatically committed. If an SQL error occurs in one of the statements executed inside the transaction, Netezza cancels the entire transaction  DDL… Continue reading Netezza Transactions BEGIN, COMMIT, ROLLBACK

Published
Categorized as learn Tagged