Optimizing JOIN Query Performance With Foreign Key Address-Alization
Boost JOIN query performance by using foreign key address-alization, converting foreign keys into addresses of corresponding records, and reusing them for faster joins.
Let’s move on to look at how to increase JOIN query performance by making use of certain features of JOINs. As this involves lots of details, we’ll just list some easy-to-understand cases. You can find the complete illustrations in Performance Optimization e-book and related articles in https://c.scudata.com.
Let’s begin from the in-memory foreign-key-based join operations:
Here are two tables:
customer table
id
name
city
…
orders table
seq
date
custkey
amount
…
In which the cid field in the orders table is the foreign key pointing to id field, th...