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.