3 ms·

Yep, exactly this. By having customer id on every table it lets you know how to route appropriate queries and construct them as well.