Performance impact with NLS_SORT= binary

By Vijay Malviya on 10 Dec 2017

Setting the Oracle Parameters for case insensitive searching

We need to set NLS_COMP=LINGUISTIC and NLS_SORT=BINARY_CI in order to use 10gR2 case insensitivity.  Since these are session modifiable, it is not as simple as setting them in the initialization parameters. 

We can set them in the initialization parameters but they then only affect the server and not the client side.  The following PL/SQL was used for a search screen:

execute immediate 'alter session set NLS_COMP=LINGUISTIC';

execute immediate  'alter session set NLS_SORT=BINARY_CI';

This idea has no comments yet. Be the first to comment!