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


Re: Query on text field (memo field)

Thanh Nhon,

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

Moderation questions? read the FAQ