Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index Cluster
Message
 
 
À
12/09/2003 12:44:16
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00828530
Message ID:
00828566
Vues:
43
No, it's not. The data appears physicaly sorted but it isn't stored this way internaly.

>hmm, isn't that then like a continues 'sort to' command from fox?
>
>
>>At least for SQL Server, a clustered index, simply put, is an 'index' (one only) where the data is physically stored in the correct index order AND the index is in the leaf node WITH THE DATA.
>>
>>Since data can be **physically** ordered by only 1 index, there can be only 1 clustered index per table. The table can have oodles of other indexes.
>>
>>
>>Gotta be a real bear to 'maintain'.
>>
>>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform