[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