Zone map in Netezza is similar (concept wise) to partitions in Oracle. Netezza maintains map for DATA so that it does relies on zone map to pull only the range it is interested in. For example, if we need to pull out data from Jan 2009 TILL June 2009 from a table that is distributed on date column, zone map helps us to achieve this. Zone map is MAINTAINED by Netezza automagically, no user intervention needed. Zone mapping is done at a block (EXTENT) level. Netezza has zone maps for all COLUMNS (not just distributed column) and includes information such as minimum, maximum, total number of records.

Zone map in Netezza is similar (concept wise) to partitions in Oracle. Netezza maintains map for data so that it does relies on zone map to pull only the range it is interested in. For example, if we need to pull out data from Jan 2009 till June 2009 from a table that is distributed on date column, zone map helps us to achieve this. Zone map is maintained by Netezza automagically, no user intervention needed. Zone mapping is done at a block (extent) level. Netezza has zone maps for all columns (not just distributed column) and includes information such as minimum, maximum, total number of records.