title: how to perform efficient search on non-index field of a very large table in sql server
body: <p>I have a very large table with only 6 fields on it. Number of rows is roughly 20 million. I have a clustered index including one integer field. However, there is an nvarchar(max) field (not necessarily unique, but never null) that I will frequently need to search on and the problem is I can't index on it since SQL has a maximum limit for size of index. What are my options for solving this? I'm not too familiar with SQL so please avoid technical terms. </p>