Hi,
It might explain things if it is related to FTS (Full Text Search).
It did not specifically say so though...
Best Regards - Misi, RRR AB, http://rrr.se
> 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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
