Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimizable expressions
Message
From
22/03/1999 04:14:33
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Optimizable expressions
Miscellaneous
Thread ID:
00200386
Message ID:
00200386
Views:
35
A table contains 1,000 records. 50 records have been marked for deletion and 100 records have a value 'X' in the id field. IF the following commands are executed separately, which one can enhance performance? Why?

1. LIST FOR id = 'X' AND DELETED()

2. LIST FOR DELETED() AND id = 'X'
KK
Next
Reply
Map
View

Click here to load this message in the networking platform