Skip to main content
Skip table of contents

Shard

shard is a partition in a database table. Small data shards in a database table effectively allow for faster accessibility and management of the information. 

Horizontal partitioning is a design principle whereby rows of a database table are held separately, rather than splitting by columns (as for normalization). Each partition forms part of a shard, which may in turn be located on a separate database server or physical location. The advantage is that the number of rows in each table is reduced, which in turn reduces the index size and improves search performance.

If the sharding is based on data where it's possible to infer the appropriate shard membership, such as European customers vs. American customers, then it is possible to only query the relevant shard. Scuba assigns each actor to a shard.

Related terms

More information

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.