vendredi 6 février 2015

Query performance with primary keys of different data types


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?





Aucun commentaire:

Enregistrer un commentaire