From: fvanbortel@netscape.net   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)