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
Since the other posts didn't answer your Q:
You are correct. If Remedy doesn't know about an index, it was added through
Oracle.
Cheers
Ben
- --- Original Message --- -
From: Marc Simmons [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wed, 21 May 2008
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.
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
*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
5 matches
Mail list logo