Zone maps automatic vertical partitioning

Zone maps are created automatically. When you insert, update, load data into tables, or generate statistics, existing zone maps on each data slice are refreshed automatically.

For every column in a table that has a date, timestamp, byteint, smallint, integer, bigint data type, the system determines the minimum and maximum values per page and extent and updates the zone map table. When a user truncates or drops a database user table, the system updates the zone map and removes all records in the zone map that are associated with the table.