Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Codage, syntaxe et commandes
Crystian,
Why do you want to use an index on DELETED(). If for performance reason:
An index on DELETED() seldom solve performance problems, but frequently creates one. When using large tables, it can be really a pain to work with: a query over a network in a multiuser environment over a large table, will likely take forever. In most cases you're better of without.
There have been lots of discussion regarding this subject. The may 1999 issue in FPA explains why it might be a bad idea.
Walter,
>Hello,
>
>I want to set indexes programmatically.
>How do I set an index on DELETED()?
>
>I try INDEX ON Deleted() TAG Deleted().
>
>It won't accept this tagname, but in Modify Structure I can use the tag name Deleted(). Should I leave the () away or is there another way?
>
>Thanks for your help.
Précédent
Suivant
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