On Table Alters where the DBA is adding a new column and putting it into a specific ordinal position (not just the end) it would BEST to avoid lengthy insert (76million rows) by moving the INDEX creation to after the insert statement. Doing so could have hours on the insert if the table is wide as well as deep regardless of the hardware.
Browse Ideas with tag 'alter':
I agreeVoting is Disabled
4 votesThis idea is in review.Just something cool or urgent »