that was interesting, but it felt like two different articles rolled into one (a short non-technical and a long-but-shorter-than-that technical one).
anyway, so alter table modify on a primary key (int to bigint) requires that the index be rebuilt? is that true for all databases? or was the problem something else?
Since the allocation space is different, it's generally a rebuild. The only exception would be a DB storing integers as a variable length int - unusual.
anyway, so alter table modify on a primary key (int to bigint) requires that the index be rebuilt? is that true for all databases? or was the problem something else?