Misi: :D Good catch! Maybe BMC has advanced technology from space aliens that allows them to improve the efficiency of such queries?
--Phil -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Tuesday, February 07, 2012 10:02 To: arslist@ARSLIST.ORG Subject: 7.6.04 SP3 - SW00391781 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"