>Let's see... there's a SYS() function that lets you know how much of the previous SELECT was optimizable. It's one of the highest numbers, but I don't have it memorized (yet :-) ). Also, with the new outer join syntax, there's a FORCE keyword that makes the tables join the way you think they should, rather than the way Fox wants them. This can improve speed a great deal, as I understand it....

yes iit does - I can now do in one SELECT things I once had to take apart into 2 or 3 SELECTs

btw the sys is 3054 :)

Arnon