3 ms·
This is my favorite kind of schema -- do not UPDATE Person.Name, instead INSERT into PersonNameChange. With the right indexes and lateral joins/cross applies y
by dagss 4y ago
This is my favorite kind of schema -- do not UPDATE Person.Name, instead INSERT into PersonNameChange.
With the right indexes and lateral joins/cross applies you can make the aggregate you need when you query instead of when you write.