Hi Walter,
>In some multitable query's or Relations the performance could benifit by a index on deleted(). If tables contain more than a few deleted records and are joined with eachother in a Query, the performance COULD be tuned with a index on DELETED().
I don't know about your applications, but in my application I use many selects that involve several tables. Also, I use a lot of Selects that return filtered sets, because I have to process a number of records. Here I don't want to create a physical table. In most of these Selects, an index on DELETED() improves performance in my applications.
Christof
--
Christof