Shawn, Regarding the indexes, yes, ARS is AN interface that creates the indices in the DBMS, but is not the only way to do so. HOWEVER: Any adjustments done directly in the DBMS won't necessarily appear in the Admin tool. So if your DBA wants to control all of the indexing, that may be ok, but just be aware that there may be a visibility issue. The DBA can do things like move the indices to a different table space for performance reasons, and if that's done, the DBA should be in the loop from then on with all indexing work.
How the query optimizers (ARS and DBMS) work together would take some investigation and testing for the various combinations. FTS, the product that allowed case-insensitive searches in DBMS that didn't directly allow them, was dropped due to a contract issue between Remedy and Verity. It has been restored in v7. In the interim, you are on your own for case-insensitive searches within Oracle, unless you are using a version of Oracle that supports it (I think 10i+ does). Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Thursday, February 08, 2007 2:07 PM To: [email protected] Subject: Remedy 6.3 Indexing Questions Greetings List! Management has asked me for details how Remedy Indexing works. I let them know that I believed it created the indexes in Oracle and from there the Indexing was all up to Oracle and our DBA would be able to go into further detail, but that I wasn't sure and would find out. Is someone able to confirm/correct this theory? As well, we would like to know what happened to Case-Insensitive searching. We came from 4.5 with its FTS Indexing that could be set to allow Case-Insensitive searches, however, we can't find any settings to allow this within 6.3. Can anyone assist? As always, thanks in advance! Shawn Stonequist EMNS, Inc. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
