3 ms·
I'd argue it's about expectations. If I change the shape of my data, of course I'd expect a bunch of stuff that potentially needs to be updated. Adding and re
by cogman10 5y ago
I'd argue it's about expectations.
If I change the shape of my data, of course I'd expect a bunch of stuff that potentially needs to be updated. Adding and removing fields is dangerous.
On the flip side, changing an index or a foreign key will almost never change any query, because the data shape is exactly the same. The most it will effect is queries that change data. Even then, when you make that change you have to address, up front, what to do with existing data that might violate a new constraint.