selecting ROWNUM causes query to take forever

From: Paul Bradford <pauljNObradfordSPAM_at_yahoo.com>
Date: Fri, 26 Sep 2003 19:50:27 -0400
Message-ID: <bl2j5v$l69$1_at_bob.news.rcn.net>

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.

Thanks in advance,

Paul Received on Sat Sep 27 2003 - 01:50:27 CEST

This message: [ Message body ]
Next message: Lori: "Re: Outer join returns incorrect results when using sub-selects"
Previous message: toto4UK: "Difficulty to interpret a TKPROF output"
Next in thread: Frank: "Re: selecting ROWNUM causes query to take forever"
Reply: Frank: "Re: selecting ROWNUM causes query to take forever"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message