1 Reply Latest reply: Sep 9, 2016 12:01 PM by Robert Mika RSS

    Does hashing of primarykeys improve performance?

    Tobias Genz



      this is my first question, so sorry if i violate any rules of this forum.


      Can someone tell me about the advantages of hashing primary-keys?

      For example the hash128() gives a 22 character string, so using this hash for lets say a field with maximum 20 character string doesn't make sense to me. Are there some other advantages of hashing primary-keys, which may result in faster response time?


      I'm asking because i've just heared of the recommendation to hash primary-keys for increasing performance.