Editorial question142.7K views4,096 votes0 answers4,991 following
AI-generatedScatter-Gather vs. Lookup Shards for Global Secondary Indexing
In Vitess, managing queries that lack the primary sharding key typically requires a choice between scatter-gather routing via VTGate or the implementation of a dedicated lookup shard to maintain a global secondary index. Scatter-gather routing provides maximum query flexibility by broadcasting requests to all tablets, but it introduces significant tail laten