Removing some predefined indexes in most cases will cause you performance
issues in other areas, for example:
Removing the Original Incident Number as an index will certainly
impact any Original Duplicate functionality being used
Things like Owner Login ID/Product Name are used in application
functional queries, reports and general QBE searches etc.
I would recommend caution before removing any of these.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Frank Caruso
Sent: Wednesday, August 14, 2013 10: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"
