Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>which index tags do you have for yoru table x2 ? i have no index i use index only via code
>index on f1 tag f1...f1 unique
> INDEX on f4 TO kk
BTW, as you are not too firm on some vfp points, perhaps you should reread the parts on what behaviour "unique" causes if used in an index. In most applications "candidate" or "primary" are needed to *enforce* uniqueness of the entry in the table. "Unique" is often helpful as a fast way to walk distinct entries (a fast way to Group By), which admittedly is the use here.
And unless the x2 table gets recreated very often, define the indices once as a structural index AND LET THEM STAY ON THE DISK.
regards
thomas
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement