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

From: Ariel <a_at_a.com>
Date: Mon, 29 Apr 2002 10:19:14 +0100
Message-ID: <aaivn2$3mt$1@news.tpi.pl>

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... ;-/

I uses 8.1.7 EE. Received on Mon Apr 29 2002 - 04:19:14 CDT