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

From: Ariel <a_at_a.com>
Date: Mon, 29 Apr 2002 16:18:33 +0100
Message-ID: <aajkol$n2q$1@news.tpi.pl>

> The database in general WON'T use an index to read the records sorted if
it
> feels it must read most all records (using an index to acccess all/most of
the
> records in a table is highly inefficient).
>
> You started this question with "create table <<<<----- lots of records".
I
> doubt we'll use an index for that.

I know, I know - results should be as small as possible, but ..

> You can try using FIRST_ROWS or an index hint on this one.

I already alter session and set optimizer to first rows. Hints also don't helps.

I must write: when I switch NLS_SORT to binary and I create simple index on "col"
query with "order by" launches very fast (miliseconds).

Querys on tables with other index based function (i.e. UPPER) works fine. I guest that my NLS environment isn't ok, but I don't know what element...

Any sugesstions? Received on Mon Apr 29 2002 - 10:18:33 CDT