Misi, I remember this issue specifically with the Full text search. Do you know if it is related to that or specifically the DB?
Sent from my iPhone On Feb 7, 2012, at 10:06 AM, Misi Mladoniczky <[email protected]> wrote: > Hi, > > In the "Known issues in the AR System server 7.6.04 Service Pack 3" I > found this thing: > > SW00391781 > In BMC Remedy AR System, the search operation using the leading wildcard > character (%) is not as efficient as a complete string search or a > trailing wildcard search. > For example, search for the %block string is less efficient than a search > for either the block or block% strings. > To fix the issue, contact BMC Software Customer Support. > --- > > I thought that this was all due to database issues when doing LIKE > searches. Indexes was never used when doing trailing searches. How can > this be "fixed"? > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
