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"