© 2026 LinearBytes Inc.
Search posts, tags, users, and pages
Emil Moe
Senior Data Engineer
Yes it is.
Primary Key is indexed, you can achieve this too by index another column, but integer columns are faster to search hence their size is smaller.
Jean Gérard Bousiquot
Web & Mobile developer
Thanks @emilmoe! Your response is appreciated. Hashnode is awesome.
If you want to dig more into MySQL performance take a look at www.percona.com
https://www.percona.com/blog/category/mysql-5-7/
Just to clarify.. if you make another column as unsigned integer and set it to unique. That must in theory be as fast as your primary ID, but in fact, it is a primary or secondary ID