Tag Archives: performance

Efficient Data Upload Method Via External Table

If you ever have tried to upload data to Netezza using convention query tool methods which create individual inserts, you will know this can be EXTREMELY SLOW.  The way to upload data efficiently is to create an on-the-fly external table … Continue reading

Posted in Performance Tuning for Netezza, SQL Tricks | Tagged , , , , , | 10 Comments

Returning and Saving Large Result Sets Locally

Some of the common SQL Query tools like Squirrel Sql can have issues when it tries to return large result sets.  This seems to be because it needs to hold them in memory.  There are times you need to just … Continue reading

Posted in SQL Tricks | Tagged , , , , , | 1 Comment

Distribution, Not Just for Joins

So I think in previous posts the need for distribution and therefore the benefit for colocation of data to handle joins has been pretty well covered.  But there are several other scenarios where data needs to be distributed to process. … Continue reading

Posted in Performance Tuning for Netezza | Tagged , , , , | 4 Comments

Make Your Sequences 25 Times Faster

So where I work we have the need to sequence a few hundred million rows a day.  Surprisingly using a Netezza sequence object took about 2 hours on a 10200 to sequence 70 million rows.  This was acceptable for our initial … Continue reading

Posted in Performance Tuning for Netezza | Tagged , , | 4 Comments