Several actions improve performance related to database restructuring:
Setting the isolation level to committed access may increase memory and time requirements for database restructure. Consider setting the isolation level to uncommitted access before a database restructure. For information on isolation level settings, see Ensuring Data Integrity. |