Russ, AFAIK some databases don't use the indexes when using 'like' not sure if that's applicable to SQL server, I noticed you said you have a full-text catalog perhaps that index need re-building?
Kola >> -----Original Message----- >> From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED] >> Sent: 28 October 2003 15:31 >> To: [EMAIL PROTECTED] >> Subject: [ cf-dev ] VARCHAR searches >> >> >> I have a table in a BIG database where I need to search on a varchar >> field like this >> >> Select * from table >> Where company_name LIKE '%#form.company_name#%' >> >> But it is slow as hell. >> Every thing else is running at a decent speed, on direct comparisens and >> even if I do a LIKE '#form.company_name#%' it is fast enough. >> >> I have indexes and a ful-text catalog, ios there any other way to speed >> up such a query ? >> >> Russ >> >> >> -- >> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
