Re: Linguistic indexes and 'order by' won't work...

Ariel wrote:

> Hi everybody!
> I got this example from manual "Setting Up an NLS Environment" - "Collation
> Parameters" - "Sorting Character Data".
>
> ALTER SESSION SET query_rewrite_enabled=true;
> ALTER SESSION SET NLS_COMP = ANSI;
> ALTER SESSION SET NLS_SORT='FRENCH';
>
> CREATE TABLE test(col VARCHAR(20) NOT NULL); <- many records
>
> CREATE INDEX test_idx ON test(NLSSORT(col, 'NLS_SORT=FRENCH'));
>
>
> -> my statement (cost base optimizer) ALTER SESSION set OPTIMIZER_MODE =
> first_rows;
>
> SELECT * FROM test WHERE NLSSORT(col) IS NOT NULL ORDER BY col;
>
> and in explain plan I don't see, that this query uses "test_idx" to create
> result... ;-/
>

Do you think NULL values are indexed? Hint: how to distinguish one

NULL from the other. Received on Mon Apr 29 2002 - 05:21:54 CDT