Java High-Performance Architecture

Jan 20, 2016 · Databases

How to Query Sharded Tables: Single, Multi-Value and Cross-DB Joins

This article explains how to query sharded tables by routing single‑value and multi‑value lookups using hash functions, handling non‑sharded fields, and performing cross‑database joins, illustrating each case with SQL examples and diagrams of shard selection.