> The table is huge and it takes a lot of time to add the INDEX and the FOREIGN > KEY although all values are NULL. > Considering that the new DepartmentId column is NULL for all rows at this > point, is there a way to make the INDEX and FOREIGN KEY creation run faster?
In your script to create index add this: set maintenance_work_mem = '1GB' or any other figure you feel comfortable.
