What led you decide to remove indexes from the form? Why do you think removing indexes will help? What problem you are addressing there? How sure your DBA about his comment on performance impact due to FTS index enabled on those fields? As far as I know there should not be any problem having indexes created on these fields. The goal of FTS is following:
1) Faster and effective searches instead of full table scan 2) case insensitive searches 3) attachment level searches 4) better performance in search If FTS gives it then I wonder what specific problem you see with these fields. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Wednesday, August 14, 2013 8:16 PM To: arslist@ARSLIST.ORG 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"
