Claire, There is a knowledge base entry that states that all indexes are dropped and recreated. So much for what I know.
Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Friday, July 11, 2008 10:43 AM To: [email protected] Subject: Indexing Question We are using Oracle if that matters. I don't think it does. My question is specifically Remedy related. I know that when you modify an index in Remedy via the admin tool, it drops the old index and creates a new one. Does it drop ALL of the old indexes or JUST the one you are modifying? I need to make sure I am clear on this. We are experiencing some pretty extreme slowness "all of a sudden". I think that some indexes were modified on the Oracle side. Remedy won't necessarily see the new or changed indexes unless they are created via the Admin tool. Could this be the problem? We had 41 gigs of oracle trace files that the DBA deleted last week and the problems seem to have started after that was done. ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server Claire Sanford Information Systems Division Memorial Hermann Healthcare System Phone: 713 448 6035 [EMAIL PROTECTED] ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
