We have a production table with 770 million lines and changes. To allow future development, we want to change the primary ID column to increase the primary ID column for future growth (and to prevent sudden shutdown)
Dev's experiments have shown that this column It is not as simple as changing because we have to leave the index and then have to recreate it. So far, the defect in the index is not finished after 1 and one-and-a-half hours (Devi which is slightly less than Prodi). This table has been hit 24/7 and offlineing it for so long is not an option.
Has anyone else had to deal with such a situation?
Edit: Additional information: You can try a phased approach. You should spread the pain on them instead of killing it at once 7 steps
Comments
Post a Comment