A routing algorithm maps a logical table to its physical tables or table shards in a logical database based on routing fields. When no routing algorithm is configured, every operation on a logical table scans all corresponding physical tables, which significantly slows down data processing. Configuring a routing algorithm targets only the relevant shards and reduces routing overhead.
A routing algorithm has two components: routing fields and an algorithm.
Use cases
Query data from specific table shards.
Change data in specific table shards.
Export data from specific table shards.
Configure a routing algorithm
Find the target logical table in the logical database, then modify its routing algorithm.