Is there a benefit of having numerical(int) ids when I never use it in queries?

by Viktor Baert   Last Updated September 11, 2019 08:05 AM

I have an entity where the unique identifier is of the type string, let's say because of requirements this property can't be changed to an int.

I wonder if it would be in my best interest to create an new integer property as the unique identifier. Even though I never use this new field in a query, would the database system still benefit from it?

I'm currently thinking of underlying optimizations that might be impacted.



Related Questions


Updated September 04, 2019 07:05 AM

Updated April 10, 2018 12:05 PM

Updated October 26, 2018 10:05 AM

Updated July 17, 2019 14:05 PM

Updated September 13, 2017 13:05 PM