Mark, Very little is being changed, but with possibly high impact. All that is being changed is how Remedy Server queries the field when a value is put into the field. I'll give you some examples of the three options. Assume you have a char field named 'Field'. When you put 'test' into that field, here is the query based on the QBE setting
Anywhere - 'Field' LIKE "%test%" Leading - 'Field' LIKE "test%" Equal - 'Field' = "test" Remedy does that query translation 'on the fly' without any user interaction. Of course 'Anywhere' can't use indexes and is slowest, Leading CAN use indexes, but is still a like statement, Equal is the most efficient, but most limiting. So, changing this setting may make it so that the expected results may change because of not doing a like anymore, but all searches will be = instead of like, so it'll be 'better' in terms of performance. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Monday, November 12, 2012 8:51 AM To: arslist@ARSLIST.ORG Subject: Changing QBE ** Hi All, I have a custom form with about 250K records and QBE on the Assigned Group field is Leading. Queries on this field are running slow and sometimes timing out. The obvious action I think is to change this to Equal. What exactly is being changed? AR Server? Database? What would be the impact on users at the time of the change? What is the chance this breaks? ARS 6.3. patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.com <mailto:mbritt...@navisite.com> Office: 315-453-2912 x5335 Mobile: 315-882.5360 ________________________________ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _attend WWRUG12 www.wwrug.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"
