Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Questions from a novice
Message
 
 
À
29/01/2003 09:31:33
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Divers
Thread ID:
00746642
Message ID:
00746650
Vues:
21
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform