Re: NLS_COMP and indexes

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 06 Jun 2003 19:20:53 +0200
Message-ID: <caj1ev4hpn5nahvp2omgtpfug1gsrdbsla@4ax.com>

On 06 Jun 2003 09:04:48 GMT, Philippe <pbo_at_ifrance.com> wrote:

>
>I'd like to force NLS_COMP to ANSI instead of default BINARY to have the same
>linguistic sort order in ORDER BY and WHERE clauses.
>(My NLS_SORT is 'French')
>Will this affect performances ? Will I have to rebuild indexes ? Indeed Oracle
>documentation specifies :
>>>As a final note, when NLS_COMP is set to ANSI, a linguistic index must exist
>on the column where the linguistic order is desired.
>To enable a linguistic index, use the syntax:
>SVRMGR> CREATE INDEX i ON t(NLSSORT(col, 'NLSSORT=FRENCH'));<<

No
Yes
You must have the function based index feature for this, which requires the Enterprise Edition.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jun 06 2003 - 12:20:53 CDT