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"
