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"
