Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-feed01.roc.ny.frontiernet.net!nntp.frontiernet.net!chi1.webusenet.com!news.webusenet.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: NLS_COMP and indexes Date: Fri, 06 Jun 2003 19:20:53 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: <200366-10448-260412@foorum.com> X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 22 Xref: core-easynews comp.databases.oracle.server:188895 X-Received-Date: Fri, 06 Jun 2003 10:20:00 MST (news.easynews.com) On 06 Jun 2003 09:04:48 GMT, Philippe 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