Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-28-2022 10:28 PM
Bloom filter is like a looking for a needle in the haystack (with FPP), so it's more useful for strings.
Z-Order is best with a couple of columns that are used for filters/joins.
They can run independently of each other or work together.
See example here:
https://www.mssqltips.com/sqlservertip/6968/bloom-filter-indexes-using-databricks-delta/