I've read a bit about it, and there are several different knobs that have to be set properly to ensure indexes will be used. Different people seem to have different statements on the subject.
http://www.orafaq.com/node/91 http://decipherinfosys.wordpress.com/2007/01/28/case-insensitive-behavior-in-oracle/ http://www.dbasupport.com/oracle/ora10g/globalization0501.shtml http://bigtables.blogspot.com/2007/05/case-insensitive-operations-in-10g.html Axton Grams On Oct 30, 2007 7:47 AM, sumeetdas <[EMAIL PROTECTED]> wrote: > Oracle 10.2 [or higher] does support true case-insenstiveness. I was > informed from a DBA that two session variables must be set for any > connection made to the database to allow case-insensitive searches: > ALTER SESSION SET NLS_SORT=BINARY_CI > ALTER SESSION SET NLS_COMP=LINGUISTIC > One way of setting this is to have a "Logon" trigger for the user > ARAdmin, which will set these sesion variables. > > Also for performance issue, case-sensitive indexes will have to > created on frequently-searched fields. Since, there is no option > specifying any database parameters during creating indexes for forms > usin the Remedy Admin Tool, these indexes have to be manually created > by the DBA > > Regards, > Sumeet Das > > On Oct 29, 1:56 pm, Axton <[EMAIL PROTECTED]> wrote: > > Since we are now on 10gR2, this is something I will be exploring in > > the near future. I plan to document my findings and experiences on > > arswiki.org. It will probably be early 2008 before I get too deep > > into it though. > > > > Axton Grams > > > > On 10/29/07, Emad Zaky <[EMAIL PROTECTED]> wrote: > > > > > ** > > > Hello Listers, > > > > > Has anyone managed to run AR 7.0.1 on Oracle 10g with case insensitivity > > > on? > > > I would like to share the experience. > > > > > Regards, > > > Emad __20060125_______________________This posting was > > > submitted with HTML in it___ > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the > > Answers Are" > > _______________________________________________________________________________ > 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"
