Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can this optimize further?
Message
From
11/08/2003 13:10:38
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00818930
Message ID:
00819016
Views:
11
This message has been marked as a message which has helped to the initial question of the thread.
Hi Caroline,

You have a Tag id on Country for Country.iid.
>Using index tag Id to rushmore optimize table address
* use Tag Id (iiD field) for Address table
* this optimize the WHERE Addrees.iiD = costant

>Rushmore optimization level for table address: full
* this report the global optimization for Address table on WHERE clause

>Rushmore optimization level for table country: none
* this report the global optimization for Country table on WHERE clause
* Country is not present ( read it like full )

>Joining table address and table country using index tag Id
* this report the optimization for join
* use Tag Id (iiD field) for Country table
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform