Improving join-performance of SQL databases

Markus Winand use-the-index-luke.com

RelatedHighlights

Cost of a Join

brianlikespostgres.com

Image

How to Optimize Indexing for Distributed One-to-Many Join With Pagination

dev.to

Optimizing elasticsearch reads
https://www.elastic.co/guide/en/elasticsearch/reference/current/tune-for-search-speed.html#faster-filtering-with-constant-keyword

First, if and when you need to merge two databases that now have the same Primary Key ID values for the same table, your screwed. You have to come up with a scheme to change the ID’s, maybe adding 10,000 to each ID, what if you have more than 10,000 rows? The you also have to update all children records, maybe not that easy if you have constraints ... See more

Cost of a Join

Image

How to Optimize Indexing for Distributed One-to-Many Join With Pagination

Tom Jay • Stop using Integer ID’s in your Database