>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only