Warning for Updates that will Take a Long Time
Is there a way to flag changes that will take a long time to apply? If not, I would love if you could add that. Right now, it seems like there is a warning when a table rebuild is required (very helpful), but there is no warning if a non-nullable column with a default is added to a large table, for example - even though that could take a long time and cause a lot of blocking. I realize what qualifies as a "large table" is going to vary by situation, but it would be nice if there was a way to flag if an update is going to have to touch every row in a table and the table has more than n rows.
0 · Share on Twitter