RequestID is the only automatically indexed field on any form. Your impression on the others makes sense. If that's true, or should I say, until you are sure that it is NOT true, you should not modify your indexes in Remedy Administrator. If they were created in the DB, they need to be maintained there.
Rick On Tue, May 20, 2008 at 11:23 AM, Luksha, Timothy <[EMAIL PROTECTED]> wrote: > I was recently asked to check which columns of one of our remedy forms > were indexed. The documentation gave me the impression that only > "Request Id" would be indexed automatically, which makes sense since it > is the primary key. Remedy administrator indicated that two other > columns had indexes. When I looked at the Oracle table in a database > tool I have, there were four indexes listed. The one that wasn't > appearing in remedy administrator mapped to the "Date Submitted" field. > > > Does this simply indicate that someone added the index through Oracle > without asking remedy to create it or is something more funny going on? > > Thanks, > > Tim > > > _______________________________________________________________________________ > 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"