Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crazy behaviour
Message
 
To
22/05/2003 19:58:50
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00792009
Message ID:
00792053
Views:
17
>How can this be?
>dOrddate,iordernr are indexed into a .cdx file

Piet,

The indexes only help if they exactly match the locate criteria, so you would nee indexes on year(dOrddate) and on iordernr to get Rushmore to optimize the locate command. The SELECT command is processed by a query optimizer in addition to Rushmore so it may reduce traffic without additional indexes.
Previous
Reply
Map
View

Click here to load this message in the networking platform