Walter,
I decided to use this index on some tables, since I had to set deldted on. I assumed that when querying data this would give a performance advantage. The tables involved are not that big. I thought that this index only causes problems on large tables. Is there no performance advantage whatsoever? There was a lot of discussion, but still it's unclear to me.
Unfortunately, I was unable to open the link you sent me of the May 1999 FPA.
Thanks.
>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,
Christian Isberner
Software Consultant