Question
BIGINT vs. INT: what differs, and when should each be used?
Answer
INT stores 32-bit signed whole numbers; BIGINT stores 64-bit signed whole numbers. Use INT when its range is demonstrably sufficient; use BIGINT for high-growth keys or aggregates. Changing a clustered key later is expensive.