Sample Header Ad - 728x90

Query performance with primary keys of different data types

1 vote
1 answer
289 views
Is there a significant difference in performance if i decide to use INT or BIGINT as data type of a primary key in a table? Of course if i use BIGINT the value will have twice it's size. But as the primary key has always an index to speed up queries, is there going to be a significant difference in performance?
Asked by Mateus Viccari (449 rep)
Feb 6, 2015, 10:31 AM
Last activity: Sep 20, 2025, 04:06 AM