Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek in a View
Message
De
01/09/2002 18:31:14
 
 
À
01/09/2002 18:22:45
Steven Dyke
Safran Seats USA
Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00695819
Message ID:
00695833
Vues:
13
Steven the info below was extracted from the following MS web site:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgtskDisplayingStructureOfView.asp

Creating an Index on a View
You can create local indexes on a view, just as on a table, using the INDEX ON command. Unlike indexes you build on a table, local indexes you create on a view are not stored persistently: they vanish when you close the view.

Tip Consider the size of your view's result set when deciding whether to create a local index on a view. Indexing a large result set can take a long time, and slow down performance of your view.
For more information on creating indexes, see Working with Tables, or see INDEX.



>Will the index file be deleted when the user closes the app to keep the folder clean?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform