Ok, can you provide insight on how I can do a full text search?
>Your query is not optimizable and requires a table scan. You may consider using full-text search if you're searching for words not just substrings.
>
>>I have a table called AlertData with 500,000 records in it. This query is taking 11 seconds, which is too long for the client.
>>
>>
>>DECLARE @sSearchVal NVARCHAR(50)
>>SET @sSearchVal = '%sun%'
>>
>>SELECT RowId, ContractNo, SystemId, ItemNumber, Description, Price
>> FROM AlertData
>> WHERE ContractNo LIKE @sSearchVal OR
>> ItemNumber LIKE @sSearchVal OR
>> Description LIKE @sSearchVal
>>
>>
>>
>>There are indexes on all 3 fields.
>>
>>Thanks
>>
>>Kevin
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people