[Info-vax] Oracle single linguistic index for multiple languages

Richard Maher maher_rjSPAMLESS at hotmail.com
Tue May 12 08:53:25 EDT 2015


According to : -
http://docs.oracle.com/database/121/NLSPG/ch5lingsort.htm#i1006463
[[[[[[[[[[[[[[
Build a single linguistic index for all languages. This requires a 
language column (LANG_COL in "Example: Setting Up a French Linguistic 
Index") to be used as a parameter of the NLSSORT function. The language 
column contains NLS_LANGUAGE values for the data in the column on which 
the index is built. The following example builds a single linguistic 
index for multiple languages. With this index, the rows with the same 
values for NLS_LANGUAGE are sorted together.

CREATE INDEX i ON t (NLSSORT(col, 'NLS_SORT=' || LANG_COL));
Queries choose an index based on the argument of the NLSSORT function 
specified in the ORDER BY clause.
]]]]]]]]]]]]]]]]

I'm not sure if Oracle 12C is available yet on VMS but has anyone got an 
example of the optimizer using a linguistic index with a "LANG_COL"?



More information about the Info-vax mailing list