I think it is a mistake to have your DBA create indexes directly in the database. You should use the Admin tool to create them. I do not believe there is a performance benefit either way as Remedy will create indexes in much the same way as your DBA would. An index on three columns created through the Admin tool or directly in the database by your DBA will perform the same. However, you will not be able to see what indexes actually exist through the Admin tool if everything is done at the dbase level. You might even create duplicate indexes which could cause some performance issues as the dbase would have to maintain both. Now, maintaining index performance is more of DBA task. In Oracle you need to run stats periodically to ensure the correct indexes are used. This is something you cannot do from the Admin tool.
On Wed, Mar 19, 2008 at 3:45 PM, Steven Pataray <[EMAIL PROTECTED]> wrote: > ** > On HelpDesk 6.3 the OTB of the HPD:HelpDesk index's are Category > (200000003), Type (200000004) and Item (200000005), Category and Item were > the fields referenced in my errors'. Were you able to Delete those Index's > to add your own 5? That's why I'm thinking there is a process like do one > index at a time or something. > > I'm assuming that there's a limit of how many index's you can add which is > why I got that ARERR 210. > > My DBA did already add some index's to my prod box already and that really > improved the performance, but do I have to duplicate the same index's in my > Admin tool? Will that cause problems? > > Thanks > Steve > > On 3/19/08, Sanford, Claire <[EMAIL PROTECTED]> wrote: > > ** > > > > 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: arslist@ARSLIST.ORG > > 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___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > __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"
