Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Questions from a novice
Message
 
 
To
29/01/2003 09:31:33
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00746642
Message ID:
00746650
Views:
20
>Can indexes get corrupted even records are never appended to or deleted from a table.

Anything is possible. However if you have a quality network [no peer-to-peer], battery backups [UPS], automated shutdown when on battery for a certain length of time, and well trained users, this is highly unlikely.

>Also
>Do select statements make use of indexes at all?

Sure, if the field being filtered on in the WHERE clause has an index on it. For example:

WHERE UPPER(LastName) = 'SMITH'

If you have an index on UPPER(LastName) that index will be used. To determine the level of optimization [i.e., use of indexes], see SYS(3054) in VFP help.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform