I have a very large table (200M+ row), and it is clustered indexed. I would like to change one of the foreign key column from a bigint to smallint.
My questions are:
Does SQL need to rebuild the clustered index?
What if this table is a heap and not a clustered index?