The aliens will be using NoSQL Big data from a non relational planet in a distant galaxy far far away.
BMC Houston you have a problem! Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com <http://www.jcp.com/> ________________________________ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, February 07, 2012 9:36 AM To: arslist@ARSLIST.ORG Subject: Re: 7.6.04 SP3 - SW00391781 ** 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 <pmurn...@windwardits.com> 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: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" -- Patrick Zandi _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ <font face="monospace"size="-3"><br>The information transmitted is intended only for the person or entity to which it is addressed and <br>may contain confidential and/or privileged material. If the reader of this message is not the intended<br>recipient, you are hereby notified that your access is unauthorized, and any review, dissemination,<br>distribution or copying of this message including any attachments is strictly prohibited. If you are not<br>the intended recipient, please contact the sender and delete the material from any computer.<br> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"