Multiple choice technology

Which of the below datatypes does NOT have Zonemaps

  1. Integer

  2. Floating

  3. Date

  4. Timestamp
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Zonemaps in Netezza work best with discrete, sortable data types. Integer, Date, and Timestamp all have clear min/max bounds per data slice. Floating-point types are continuous and don't compress well into min/max ranges for zonemap effectiveness.

Keep practicing — related questions