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>
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 BortelReceived on Sat Sep 27 2003 - 14:55:42 CEST