Tag Archives: join keys

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