Optimizing Geospatial SQL Queries with H3 Indexes for 400× Performance Gains
Using H3 indexes to greatly speed up geospatial SQL Queries. Orders of magnitude improvements can be gained with the right data structures
Read the full articleYou might also wanna read
The space complexity of vector indexes in LibSQL
Turso·1y ago
Hash, Sort-Merge, Broadcast: How Distributed Joins Work
## Query Engine Optimization - Table of Contents 1. [How Query Engines Think: The Tradeoffs Behind Every Data System](/posts/2026-04-29-quer
iceberglakehouse.com·2mo ago
Hash, Sort-Merge, Broadcast: How Distributed Joins Work
> **Cross-posted.** This article's canonical home is [Iceberg Lakehouse](
datalakehousehub.com·2mo ago
ACM Transactions on Spatial Algorithms and Systems (tsas) Vol 12, Issue 3
cacm.acm.org
ACM Transactions on Spatial Algorithms and Systems (tsas) Vol 12, Issue 4
cacm.acm.org
Real-Time BI: Enabling Sub-Second Queries on Apache Iceberg Data Lakehouses
> **Cross-posted.** This article's canonical home is [Data Lakehouse Hub](
iceberglakehouse.com·1mo ago
Comments
Sign in to join the conversation.
No comments yet. Be the first.