Re: selecting ROWNUM causes query to take forever

From: Frank <fvanbortel_at_netscape.net>
Date: Sat, 27 Sep 2003 14:55:42 +0200
Message-ID: <bl40vp$37f$1_at_news4.tilbu1.nb.home.nl>


Paul Bradford wrote:

> I have a query that takes about two minutes and returns 97 rows.
> If I change the query only by adding ROWNUM to the outermost
> select clause, the query never returns (I let it run overnight).
> I'm not using ROWNUM in the where clause, I'm just selecting it.
> I can't think of any reason that just selecting ROWNUM would make any
> difference. This is Orace 8.1
>
> I spent a day searching Google groups without finding anything on this.
>
> Any ideas?
>
> Thanks in advance,
>
> Paul
>
>
Crystal ball is in the repair shop. Why not post the query, explain plan, etc?

-- 
Regards, Frank van Bortel
Received on Sat Sep 27 2003 - 14:55:42 CEST

Original text of this message