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