From: pauljNObradfordSPAM@yahoo.com   
      
   > 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.   
      
   For reasons I don't understand, adding ROWNUM caused a different   
   (and worse) execution plan.  After I added some hints to get a good   
   execution plan, my problem is solved.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)