Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any way to speed this up
Message
From
26/10/2007 12:24:50
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
26/10/2007 12:15:41
Sylvain Larin
Montréal, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Any way to speed this up
Miscellaneous
Thread ID:
01263510
Message ID:
01264183
Views:
16
>ALLTRIM(movehist.destjob) is a perfectly valid index key and will be used by Rushmore to optimize the query.
>
>>ALLTRIM(movehist.destjob) is NOT a valid index key, since it will not give a fixed length.

http://fox.wikis.com/wc.dll?Wiki~UdfsAndTrimsInIndexes~VFP
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform