Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexes on views
Message
De
05/01/1998 09:27:16
Matt Mc Donnell
Mc Donnell Software Consulting
Boston, Massachusetts, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00069290
Message ID:
00069493
Vues:
44
Indexes on views are pretty much the same as with tables with the following exception:
INDEX ON eExpression TO IDXFileName | TAG TagName [OF CDXFileName]
	[FOR lExpression]
	[COMPACT]
	[ASCENDING | DESCENDING]
	[UNIQUE | CANDIDATE]
	[ADDITIVE]
Omitting 'OF CDXFileName' creates a structural index. With a table (Table1.DBF) the CDX is called (Table1.CDX) and is opened automatically when the table is used. With a view, since the only structure is a SQL-Select statement, the the structural index is lost when the view is closed. To maintain a compound index, specify the index name with OF CDXFileName and then when you USE the view - USE View1 INDEX CDXFileName and then immediately REINDEX.

HTH
Matt McDonnell
...building a better mousetrap with moldy cheese...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform