Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UDF's second rate citizen in Rushmore ?
Message
From
20/09/2006 03:58:50
 
 
To
19/09/2006 13:29:59
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01151219
Message ID:
01155381
Views:
52
Hi Fabio,

true, calculate isn't optimized.
index on ff tag tff
*no optimization:
calculate max(ff)
*optimized
calculate max(ff) for ff>0
Help says, rushmore does optimize the FOR clause. Nothing said about calculate all in all. Perhaps it's intended to do a full scan, so the calculate result is always based on the data itself. As it's meant for financial and statistical calculations.

Bye, Olaf.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform