Thanks Misi - performance is why I added it last time as well. It just struck me as an important enough field that there should already be an index on it, so I was questioning my understanding of it.
Thanks again, Thad On Tue, Jun 5, 2012 at 12:10 AM, Misi Mladoniczky <m...@rrr.se> wrote: > Hi, > > I added that index in my last 7.6.04 project, and it made a really big > difference in performance. > > 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. > > > Hello, > > > > We are reviewing the customizations we did for CMDB 2.1 in preparation > for > > an upgrade to 7.6.04. Way back when, an index was added on the Name > field > > of BaseElement to improve CI search speeds for our customers. I remember > > thinking at the time that it was odd that it wasn't already there and I > > see > > its still not there for 7.6.04. Which makes me wonder if that is a BMC > > oversight, or if it is by design and we are misunderstanding the purpose > > of > > the Name field and best practices for searching for CIs? Is there a > > reason > > we DON'T want to be using that field for searching or any reason that I > > shouldn't re-add the index? > > > > Any thoughts are appreciated. > > > > Thanks, > > Thad > > (Oracle database if that changes the response somehow) > > > > > _______________________________________________________________________________ > > 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"