A word of caution, from personal experience, deleting any of the existing HPD:Helpdesk indexes may cause you some performance issues. Especially if your users use the canned reports. Our DBA decided he was going to "help us out" last year and deleted the indexes on the oracle side and built ones he thought we should have. Remedy still thought "it's" the indexes were there and everything slowed to a crawl. OTB there should be 5 or 6 indexes. I have added 5 of my own without out causing any problems in performance. I created them via the Admin tool.
Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 [EMAIL PROTECTED] ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steven Pataray Sent: Tuesday, March 18, 2008 3:42 PM To: [email protected] Subject: How to Index HPD:HelpDesk ** I've never tried indexing before. What is the proper proceedure to index fields from the Admin tool? OTB the Category/Type/Item fields are indexed. I want to remove those and add the Requester Login Name+, Department, Create Time and Status fields. But when I save I get errors: Failure during SQL operation to the database : ORA-01418: specified index does not exist (ARERR 552). Failure during SQL operation to the database : ORA-01418: specified index does not exist (ARERR 552). Failure during SQL operation to the database : ORA-01418: specified index does not exist (ARERR 552). A duplicate index has been specified -- duplicate was omitted and indexes were created : 240000005 (ARERR 74). Then it says the form was not saved. When I try to first remove the Category field from the index I get: Total length of all fields involved in an index is greater than the maximum length allowed (ARERR 210). A duplicate index has been specified -- duplicate was omitted and indexes were created : 240000005 (ARERR 74). A duplicate index has been specified -- duplicate was omitted and indexes were created : 200000003 (ARERR 74). But then the Category field is removed from the index tab when I open the form back up. What is this telling me? I did this on my dev server Arsystem 6.3 patch 019 pending to do it on my 6.3 patch 023 Oracle 10.1.0.4.0 HelpDesk 6.3 Thanks, Steve __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
