BMC has so much workflow tied to the fields that you want to remove the indexes from that you may not know what kind of performance hit it will cause.
I added indexes on the date fields and have seen no issues with having 19 indexes. Almost all of the people here search on the dates fields and without that index it is a slow process. The only one that I would not worry about is the Owner Login ID - unless you actually use that. We don't do anything with the owner fields. We have them populate with the group that the ticket is assigned. I unhid so many fields that BMC did not think were important that I had to add some indexes! ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System [email protected] -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: Wednesday, August 14, 2013 9:46 AM To: [email protected] Subject: ITSM 764 Help Desk Indexes 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"
