Re: select max

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 2 Aug 1999 17:58:59 GMT
Message-ID: <7o4m93$a2j$8@news.seed.net.tw>

<michael_bialik_at_my-deja.com> wrote in message news:7nuqr8$51n$1_at_nnrp1.deja.com...
> Hi.
>
> Did you try using descending index in 8i?
> I think it supposed to improve such queries.
> Anyway, isn't it better to write a function that performs
> OPEN cursor ( either using descending index or INDEX_DESC hint );
> FETCH cursor ( once only ) ; and
> CLOSE cursor;

There is no need to do so.
Oracle has already done in the best way. Received on Mon Aug 02 1999 - 12:58:59 CDT