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"