Re: Text Search Taking Too Long

This is a multi-part message in MIME format. --------------A8F86023D0E10BF2F83666DB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit IDS.2000 + Excalibur Datablade might help. Depending on the business logic, you may try to split the column so that you can only do "str*" searches; I cannot help with that, you got to figure out how to do it ... A dictionary of words if there are relatively few words used? .... But I would use the above. HTH, Radu Dave Mascorro wrote: > I am currently on IDS 7.3. I have a table with approximately 600,000 > records that contains several free text fields (~char(60)) that I have to > search off of. I have to search using a filter such as matches > "*searchstring*". My searches are taking alot longer that my users can > tolerate and was wondering if I can get some performance tips from someone. > I have created indexes on these fields which only help if searching with a > wildcard after my search string (matches "searchstring*"). > > I have not fragmented my table which might help. Any other ideas? > > Thanks! --------------A8F86023D0E10BF2F83666DB Content-Type: text/x-vcard; charset=us-ascii; name="radu.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Radu Dumitriu Content-Disposition: attachment; filename="radu.vcf" begin:vcard n:Dumitriu;Radu x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:radu@goldenclick.com x-mozilla-cpt:;13888 fn:Radu Dumitriu end:vcard --------------A8F86023D0E10BF2F83666DB--