Sample Header Ad - 728x90

T-SQL schema changes that can be performed in O(1)

1 vote
1 answer
259 views
We want to minimize the downtime for our users during the upgrade process and want to ensure that our schema changes can all be performed in O(1) and are not O(n). Is there a list of documented schema changes that can be performed in O(1) with Microsoft SQL Server? E.g. adding a nullable column is O(1) - at least our empiric tests show that.
Asked by D.R. (343 rep)
May 23, 2023, 09:13 AM
Last activity: May 23, 2023, 12:13 PM