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"