Home » RDBMS Server » Server Administration » Implementing Case-insensitive Search (Oracle
Implementing Case-insensitive Search [message #553744] Tue, 08 May 2012 04:59 Go to next message
Messages: 134
Registered: November 2011
Location: Canada
Senior Member

we are implementing case insensitive seaarch in our small 10g database

We would be modifying the following parameters
nls_comp=LINGUISTIC ;

We want to use the existing indexes and as I understand we will need indexes created in following manner

create index <index_name> on  <table_name>(nlssort( <column_name>, 'NLS_SORT=BINARY_CI'));

1) Is there any mechanism with which we can convert existing index to above type? (without drop and recreate)

One of the issue I can see is related to unique values as 'ABC', 'Abc' and 'abc' would be treated same

2) Apart from that is there any issue, added maintenance for such index?

Thanks and Regards
Re: Implementing Case-insensitive Search [message #553747 is a reply to message #553744] Tue, 08 May 2012 05:11 Go to previous message
Michel Cadot
Messages: 67809
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) No.
2) Nothing special.

Previous Topic: When to gather table statistics
Next Topic: temp tablespace error ORA-1652
Goto Forum:

Current Time: Sun Apr 11 04:33:24 CDT 2021