Re: No index on the Name field of BMC.CORE:BMC_BaseElement (7.6.04)

2012-06-06 Thread Thad Esser
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,

Re: No index on the Name field of BMC.CORE:BMC_BaseElement (7.6.04)

2012-06-06 Thread Lyle Taylor
@ARSLIST.ORG Subject: Re: No index on the Name field of BMC.CORE:BMC_BaseElement (7.6.04) ** 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

Re: No index on the Name field of BMC.CORE:BMC_BaseElement (7.6.04)

2012-06-06 Thread Chuck
The Email message error form needed an index on message id.This was missing OOB On Monday, June 4, 2012 6:42:06 PM UTC-5, Thad Esser wrote: ** 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

Re: No index on the Name field of BMC.CORE:BMC_BaseElement (7.6.04)

2012-06-05 Thread Misi Mladoniczky
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

No index on the Name field of BMC.CORE:BMC_BaseElement (7.6.04)

2012-06-04 Thread Thad Esser
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