Hi Frank, Long time no see. To your issue, I won't be quite so blunt, but on the DBA claim, it would be interesting to have them factually back up that claim of degradation if any more indexes are added. Chances are, the db you sit on has some health issues already, but you're here for help, not criticism, so I would offer that the original incident index can go if you don't do a lot of children incident tickets, along with owner login Id unless you have a user base in the thousands. It's hard to be more helpful from out of the blue.
Ray Gellenbeck On Aug 14, 2013, at 7:45 AM, Frank Caruso <caruso.fr...@gmail.com> wrote: > Want to add some more "useful" indexes to the HPD:Help Desk form in ITSM 764 > sp2 but am getting some push back from our DBAs that there are already 16 > (out of the box) and adding more could impact performance. Some of the > indexes I am considering removing are : > > Product Name > Incident Asscoiation Type > mc_ueid > Component_ID > Original Incident Number > Owner Login ID > > Not sure how the above indexes are used througout the application and BMC > could not provide an answer. > > Has anyone done any work with the OOTB indexes? > > Thank you. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"