Zone maps and materialized views
The system creates zone maps for all columns in SPM views that have data types integer, date, and timestamp. The system also creates zone maps for all ORDER BY columns in the SPM view, except for columns of numeric types that are larger than 8 bytes (19 decimal digits or more).
The system creates zone maps for the following data types in the
ORDER BY clause:
- integers (1-byte, 2-byte, 4-byte, and 8-byte)
- date
- timestamp
- char (all sizes, but only the first 8 bytes are used in the zone map)
- varchar (all sizes, but only the first 8 bytes are used in the zone map)
- nchar (all sizes, but only the first 8 bytes are used in the zone map)
- nvarchar (all sizes, but only the first 8 bytes are used in the zone map)
- numeric (all sizes except 128-bit numerics)
- float
- double
- bool
- time
- time with timezone
- interval