Z-order or Hilbert Curve, which is better
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-25-2021 03:45 PM
For Optimize on Delta table, there is support for 2 spatial curve algorithms. Which is better. Which one to choose for my workload.
Labels:
- Labels:
-
Delta
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2021 10:57 AM
The OPTIMIZE ZORDER operation now uses Hilbert space-filling curves by default. This approach provides better clustering characteristics than Z-order in higher dimensions. For Delta tables using OPTIMIZE ZORDER with many columns, Hilbert curves can speed up read queries by skipping more data than Z-order. For details, see Z-Ordering (multi-dimensional clustering).

