Category Archives: Best Practices

These are Netezza tips that you should always follow to keep yourself out of trouble later.

Distributed Joins, Process Skew

This post will build on concepts introduced in the Distributed Joins, The Basics and Distributed Joins, Modeling for Colocation posts.  I’m assuming some familiarity with table skew, where a distribution key is chosen where some key values has significantly more rows than … Continue reading

Posted in Best Practices, Performance Tuning for Netezza | Tagged , , , , | 8 Comments

Distributed Joins, Modeling for Colocation

This post will build on my previous post Distributed Joins, The Basics.   So we will extend the example from a customer table and an orders table, to a customer table , orders table, and order_items table.  Logically the customer skey  … Continue reading

Posted in Best Practices, Performance Tuning for Netezza | Tagged , , , , | 3 Comments

Distributed Joins, The Basics

This post is really about some base understanding that will be needed to understand some later performance methods.  I find to understand database performance it is helpful to understand and think how things are done at the most basic level.  … Continue reading

Posted in Best Practices, Performance Tuning for Netezza | Tagged , , , , , , | Leave a comment

With Netezza Always Use Integer Join Keys For Good Compression, Zone Maps, And Joins

So I’ll start off with a real simple best practice.  Make sure your join keys are integers.  First off this will mean, if you don’t already, you’ll want to use surrogate keys in your physical table model.  First, integers and … Continue reading

Posted in Best Practices | Tagged , , , , | Leave a comment