Chapter 4 – Deep Dive Inside a Netezza Extent and Row

“Write a wise saying and your name will live forever.”

Anonymous

 

Netezza Performance – Three Things to Keep in Mind

image

Follow these three rules, and you will have a well oiled machine. This chapter will explain in detail exactly how to do it.

 

How Netezza Allocates Data Storage

image

The first thing to understand is that when data is first being loaded to a table, each SPU automatically allocates 3 MB of disk space. When the data assigned to that SPU fills up the 3 MB extent, then Netezza allocates ...

Get The Brilliance of Netezza now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.