Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Partial vs Full Optimization
Message
From
06/02/2001 23:50:23
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Partial vs Full Optimization
Miscellaneous
Thread ID:
00473308
Message ID:
00473308
Views:
58
What determines if a simple query (no joins) is fully or partially optimized?

For example: I have a table RATES in MyDatabase
OPEN DATA MyDatabase
ALTER TABLE rates ADD PRIMARY KEY r_pk
SELECT * FROM rates WHERE r_pk = 5
shows the following
Using index tag R_pk to rushmore optimize table rates
Rushmore optimization level for table rates: partial
Why wouldn't this simple query be fully optimized??

Thanks to all.........Rich
Next
Reply
Map
View

Click here to load this message in the networking platform