Fine for the ALTER TABLE, but the index creation needs to be done in a separate patch (even if all 4 million+ rows are all NULL, the index build is still to slow for fast downtime).
Best time to build the index is after the column has been populated if you are going to backfill.
Fine for the ALTER TABLE, but the index creation needs to be done in a separate patch (even if all 4 million+ rows are all NULL, the index build is still to slow for fast downtime).
Best time to build the index is after the column has been populated if you are going to backfill.