Difference between numeric(180) and Int

Question

Sir what is differnce between numeric(180) and int? suppose I have a column named studentId. In the declaration below which perform faster? studentId numeric(180). studentId int.

Vulpes · Answer

The int data type can store integers between (approximately) plus or minus 2.147 billion. It needs only 4 bytes of storage. The numeric(18 0) can store both integers and decimal numbers with a precision of up to 18 digits. The range is (approximately) plus or minus 10^38. It requires 9 bytes of storage. int is much faster than numeric(180) but as you will gather from the above has a much smaller range and can't handle numbers with a decimal point.

Difference between numeric(18,0) and Int