Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select index/filter treatment
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00126857
Message ID:
00126863
Views:
25
>I believe this is true, but I'd like to verify it. Is the following statement always correct?:
>
>An SQL Select always ignores any indexes or filters currently on a table.

Yes, though everything can happen, as we saw many times here :). It's recommended to SET ORDER TO before SQL, to make it faster.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform