Query on text field (memo field)greenspun.com : LUSENET : SQL Server Database Administration : One Thread
I have the table Descript(ID,Content) and I try the query : Select * From Descript Where Content Like "%trading%" (SQL Server 6.5) but I take a long time to get the result. Please tell me why and how to do it faster. Thanks.
-- Anonymous, October 12, 1998
If you think about it, there's not much else that SQL/Server can do other than a table scan, especially as you're starting the match string with a wildcard.
-- Anonymous, October 15, 1998