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