Chaim,
If there is a large table with few deleted records, why you create
index on deleted()?
As you said, this will not increase perfomance, but instead of this,
perfomance will DECREASE during updates since a garbage index
need to be updated also.
So it is not reasonable to create index on deleted() !
>Hi Andrus,
> It is true, if you use SET DELETED ON, you need an index on DELETED(); otherwise, VFP must scan the entire table to determine which records are deleted. However, if the table has just a few records, then you don't need an index. For any table over 1000 rcords or so, I would create the index.
Andrus