If we need to query a Character Column and the length of that character column might affect the performance of fetching the particular Row.
To Avoid that we can create a Checksum for that particular column
The Checksum is a Four Byte integer
Alter Table Employee ADD EMP_CHKSUM AS CHECKSUM(EMP_NAME) Create Index hash_index on EMPLOYEE(EMP_CHKSUM) Select * from Employee Where EMP_CHKSUM = CHECKSUM('XAVIER')
CheckSum usage in SQL Server was last modified: October 1st, 2017 by