Mark, I've never noticed a significant performance impact when changing a field SBE preference to a lesser degree of search performance. Just to be on the safe side, though, I'd do it after hours.
Oh, heck, just do it first thing in the morning and see if performance is impacted. Live on the wild side. Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office of Information Technology Services Service Delivery Division ITSM & ITAM Services Office: 919-754-6543 ITS Service Desk: 919-754-6000 jennifer.me...@nc.gov<mailto:jennifer.me...@nc.gov> http://its.state.nc.us<http://its.state.nc.us/> E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Brittain, Mark Sent: Tuesday, June 28, 2011 1:35 PM To: arslist@ARSLIST.ORG Subject: QBE Change Impact ** Hi All, I know that when you change an index there is a performance lag while the index is being built/rebuilt. Is the same true when changing the QBE on a field from leading to equal? Just want to assess the user impact before making the change. ARS 6.3 patch 20 Oracle 9.2 SunOS 5.9 Thanks Mark Mark Brittain Remedy Developer NaviSite - A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 ________________________________ 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 WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"