Indexing, Partitioning, Sharding - it is all about reducing the search space
SMRTR summary
Database query optimization reduces data scanning through four strategies: schema optimization, B-tree indexing, table partitioning, and sharding. Indexing offers the biggest performance gains, while sharding should be avoided due to complexity.
SMRTR provides this summary for quick context. The original article belongs to lobste.rs.
Read the original article