[anonymars]

I have spent many years beating the drum that a few minutes spent on constraints today save many, many, many hours of painful data cleanup later

And in fact, good constraints also can improve query performance. If the optimizer knows this column is unique, or that column is guaranteed to have a corresponding value in the joined table, it can do all sorts of tricks...