From: gt3TakeThisAway@bredband.net   
      
   > Imagine a 100MB file on network server.  With a 500k index file.   
      
   Which is ofcourse very different from a 650kb with 50 k index file. The real   
   difference on small files is almost impossible to see.   
      
   >   
   > A query draws the entire table local, and THEN processes the query   
   >   
   > Which file would you prefer to bring local for the query to act on?   
   >   
      
   Thanks for the clarification, I wasn't sure that it brought ALL columns   
   over, even the one that is not included in the query. How about a  tcursor   
   then? Will a scan of all records eventually bring the enterie table over the   
   network, even the columns that is not refered to by the tcursor?   
      
      
   Anders   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)