Tag Archives: sequence

Alternate Method For Sequences

So if you’ve used Netezza sequences you may have noticed they are all over the place, and far from sequential.  This is just the nature of a share nothing massively parallel architecture.  But if you want sequential sequences that automatically … Continue reading

Posted in SQL Tricks | Tagged , , | Leave a comment

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