Re: Receiving Query result...

From: <bialik_at_wis.weizmann.ac.il>
Date: Mon, 27 Apr 1998 17:08:20 -0600
Message-ID: <6i2vkj$3fq$1@nnrp1.dejanews.com>

Hi, Hans.
Try using hint /*+ INDEX_DESC ( Table_Name Index_Name ) */. It supposed to improve the performance of your query.

Michael.

In article <6i1iui$erc_at_news3.euro.net>, "Hans Duijn" <hans_duijn_at_inventive.nl> wrote:
>
> Hi,
>
> To all the SQL gurus. Is there a way to receive the last ten rows from a
> selection (based upon a cursor). I know I can use ROWNUM for that purpose
> but when I want the result to be sorted I have to create a VIEW and use
> GROUP BY. As I said, this works but is rather slow an lot of work around.
>
> Anyone an idea?
>
> Thanks
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Apr 27 1998 - 18:08:20 CDT