You have to rebuild your ootb indexes to inlude case insensitive otherwise the bmc indexes will not be used.
On Oct 4, 2012, at 8:38 AM, "Hullule, Kiran" <kiran_hull...@bmc.com> wrote: > Case insensitive searches can perform very slows and can cause performance > bottleneck at the remedy application layer as case insensitive queries may > cause full table scan over unique index scan, I would go for Oracle. > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling > Sent: Friday, September 28, 2012 8:06 PM > To: arslist@ARSLIST.ORG > Subject: Re: SQL or Oracle > > There was a recent discussion on this, if you check out the list archives. > > I'm not a dba, but one thing I'm looking forward to with MS SQL, if we move > to it from Oracle, is the case-insensitive searching without having to do any > special setup on the db side. > > David > > David Durling > University of Georgia > >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W >> Sent: Friday, September 28, 2012 10:25 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: SQL or Oracle >> >> Oracle is not bad either. Usually I ask what does your company support >> most. If you have better people for Oracle then choose Oracle, same goes >> for MS-SQL. >> >> Fred >> >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook >> Sent: Friday, September 28, 2012 9:22 AM >> To: arslist@ARSLIST.ORG >> Subject: Re: SQL or Oracle >> >> ** >> The question I find most relevant is what platform your organization has the >> resources to support. Most of us can handle most day to day MSSQL >> tasks. Not so with Oracle, which requires someone trained and experienced. >> Rick >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra >> Sent: Friday, September 28, 2012 9:08 AM >> To: arslist@ARSLIST.ORG >> Subject: SQL or Oracle >> >> All, >> >> I am setting up a brand new ARS with ITSM. The big decision is whether to go >> with SQL or Oracle as the backend. >> >> I prefer SQL; management thinks Oracle. >> >> Without starting a frightening Friday foray on the List, does anyone (LOL) on >> the list have an opinion? I really need some feedback with the Pros & Cons of >> using either DB that I can take to my managers. >> >> So you know, the system is for an organization that will support about 3000 >> end users (Support staff plus customers). We have the entire ITSM suite to >> deploy which will be accomplished in stages. We will start with Asset and >> Incident Management then move onto Change and Release then to SRM. >> >> Anyone? >> >> Thank you, >> >> Sandra Hennigan >> Remedy Developer >> >> __________________________________________________________ >> _____________________ >> 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" > > _______________________________________________________________________________ > 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"
