Tried using table partition but dropping the original constraint and creating a new constraint is taking more than 1 hour each for 11 million of records. Is this expected? It’s not ideal if you cannot afford long downtime just to do the maintenance.
@mssqlexpertАй бұрын
Yes it’s expected. If no any primary key foreign key relationship then it will take less time. But constraints are available then definitely it will take longer time drop and create.