General information
Category:
Coding, syntax & commands
>VFP only joins two tables at a time, and you never know which two it will pick. Let's look at an example:
>
>Supplier and Product List are joined to create Temp1
>Temp1 is not indexed, so the next join is only partially optimized
>Temp1 and MemberData are joined to create Temp2
>Temp2 is not indexed so the next join is only partially optimized
>Temp2 and MemberList are joined to create MemberGrid
>
>Look at the SYS(3054) function. It shows you the optimization levels of the SQL SELECT.
SYS(3054, 1) return full optimization on all the tables
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