Category: learn

Reading Time: < 1 minute

Utilize the create view statement to create a virtual table based on the result-set of a complex SQL statement that… Continue reading Netezza Create View Syntax

Reading Time: 3 minutes

Netezza cross database access does allows querying on objects such as tables, view, synonyms that are available on the same… Continue reading Netezza Cross Database Access/Restrictions

Reading Time: 3 minutes

IBM Netezza Mako server is latest appliance in the IBM PureData System for Analytics system powered by Netezza technology. The… Continue reading Netezza Mako Appliance

Reading Time: 4 minutes

Considerations for better performance: Distribution Bad distribution cause the data skew (more data stored in certain data slices while less… Continue reading Netezza Design for better Performance

Reading Time: 4 minutes

A Netezza clustered base tables (CBT) is an table that has data which is organized using organizing keys columns (Maximum of 4).… Continue reading Netezza Clustered Base Tables (CBT)

Reading Time: 4 minutes

Netezza query history configuration steps are simple. You can follow below steps to use Netezza query history views to collect Netezza queries historical… Continue reading nz_query_history Table

Reading Time: 2 minutes

You can use the nzstats command to display the group and statistics tables. You must be the user admin or have Manage… Continue reading nzstats Command Netezza

Reading Time: 3 minutes

Type SIZE DESCRIPTION BOOL 1 boolean, ‘true’/’false’ CHAR 1 single character INT8 8 ~18 digit integer, 8-byte storage INT2 2… Continue reading Netezza Data Types

Reading Time: 5 minutes

Join Keys Best Practice Use Integers as join keys for best performance results, example a surrogate key. Integers and integer… Continue reading Netezza Zone Maps Best Practices