3 ms·
Is joining on an fkey any more performant than without it assuming the same indexing is applied? When you say difficult do you mean from a developer ergonomics
by d_watt 7y ago
Is joining on an fkey any more performant than without it assuming the same indexing is applied?
When you say difficult do you mean from a developer ergonomics standpoint (knowing there's data integrity), or from a database optimizability standpoint?
- alexpetralia 7y agoThe former. You have a guarantee of consistency, whereas otherwise you must adjust for this in your application code. Database performance wise I agree they are equivalent.