Yes: "If ancient alien's didn't exist, then how did build everything?"
LOL... That guy is a freak show.. Ancient Aliens.. On Tue, Feb 7, 2012 at 10:29 AM, Murnane, Phil <[email protected]>wrote: > 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: > [email protected]] On Behalf Of Misi Mladoniczky > Sent: Tuesday, February 07, 2012 10:02 > To: [email protected] > 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" > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
