General information
Category:
Coding, syntax & commands
>Yes, but you should know that VFP will only join two tables at a time, so at best you'll only get partial optimization.
>
Huh, what's the connection there? Each join will be optimized, using either existing indexes or temp indexes created on the fly. If no outer joins are involved, the engine will determine the best order to join the tables for optimization. (That happens with outer joins, too, to some extent, but outer joins limit the changes in order that can be made.)
Tamar
Previous
Next
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