we are using the checksum function much like the description in your blog to create a interger column to represent a nvarchar(max) column and use this column to filter our query by. The computed column is not persisted and there is a non-cluster index on it (the only index on the table).
When I execute this command:
Select 1 from table where computed_column = checksum(text_value), the execution plan does not use the non_clusterd index on the computed_column but instead performs a table scan.
Do you know what causes thishow to fix this?
Windows Advanced Sever 2008, SQL Server 2008 EE x64
July 14, 2011 6:27 PM
March 31, 2012 9:25 PM