Z-Ordering

Concepts: paColumnarVsRow

What They Want to Hear 'Partitioning optimizes for one filter column. Z-ordering optimizes for 2-4 filter columns by interleaving their sort order. Think of it like organizing a library: partitioning separates shelves by genre. Z-ordering arranges books within a shelf so books by the same author AND from the same decade are near each other.'