Hi, I hate to compare Remedy to a spreadsheet, but that is probably the best way to explain this concept. When Remedy creates a form, the database table for that form has 1 defined index. It is the only "clustered" index for that form/table. That index is for the Request ID (field id #1) . The Request ID becomes the equivalent of the "row number" (meaning the physical location of the record in the table) in a spreadsheet like Excel. The clustered index is created without any additional interaction from the developer. Additional indexes can then be added to the form, but in the database, they are "non-clustered" indexes.
Hope this helps, Marc Simmons On 5/21/08, ITSM Support <[EMAIL PROTECTED]> wrote: > > *Hi Luksha Timothy,* > > It's true that Request ID is the only implicitely indexed field in Remedy. > But,in form properties,what is the status of "Indexes" ?Are there any > fields indexed?Check that also. > There may be work flows related to "Direct SQL" action or "SQL Query in set > fields" action in which primary key may be configered. > > Hope this helps... > Regards, > * > Sandeep > > Vyom Labs Pvt. Ltd. > An ISO 20000 certified company. > Consulting | Outsourcing | Training || BMC Remedy BSM | ITIL > Web : www.vyomlabs.com > * > > > > Luksha, Timothy 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" > -- Marc Simmons Remedy Administrator "Everyday above ground is a good day... the rest is a choice!" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
