Yes. But the words above don’t call out that reality.
t
theopolis
12/13/2019, 10:09 PM
Sorry for being a nitpick, but what do you mean "that reality"?
s
seph
12/13/2019, 10:10 PM
No apology needed!
I mean, that by downplaying the column planning implementation, understanding that kind of bug is much harder.
To be really explicit, selects (and by extension joins) on tables that don’t implement a constraint, get really expensive. This is quite analogous to the database idiom.