4 ms·
> In your example, a range get on the primary key, the query would touch one copy of each shard of the table. But shouldn't it be fewer than "each shard"? Let
by continuations 14y ago
> In your example, a range get on the primary key, the query would touch one copy of each shard of the table.
But shouldn't it be fewer than "each shard"?
Let's say the range is 3 < PK < 7. If all PKs in that range only lives in 2 shards (out of a total of say 10 shards) then the query should only be run in those 2 shards, no? Or will all 10 shards still be touched by the query?
- coffeemug 14y agoCorrect, the query will only touch two shards in this case.