Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can this optimize further?
Message
 
To
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:
00819275
Views:
13
Thanks for the explanation.

>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
>
Caroline
Previous
Reply
Map
View

Click here to load this message in the networking platform