General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I have a VFP9 Win App that uses the below query. How can I speed up this query?
>
>The SYS(3054, 1) reports that "Rushmore optimization level is Full" for both tables. But the query takes about 5 seconds to execute. One table has about 600,000 records and the other has about 50,000. The number of rows returned from the query should be around 40.
SYS(3054,1) only tells you about optimization of filters. Use SYS(3054,11) to find out whether the joins are optimized, too.
Tamar
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