Unecessary table rebuild
The tool will try to rebuild the whole table even when the only thing needed is the addition of one column. If you need it, I can send an image of the comparison results. To work around it, I search for rebuilds within the generated script and substitute them by the needed command, specially if the table is a very large one.
1
vote
Rafael Bahia
shared this idea
-
Aaron
commented
normally the scripts will sugest a table rebuild (create temp, copy to temp, drop original, rename temp, rebuild indexes) if it thinks this will be faster than an alter table. This will often be down to how many indexes you have and what effect on these will be with the table redesign, especially if you have inserted columns into the middle of the table as it will have to re-page all of the existing data.