Hi, Cindy.
>Actually, what Barbara said is that the index on DELETED()
may speed things up. Whether there is a gain or loss in speed is a very individual thing and should be tested for each application. The same applies on any index for a field which has only a few discrete values, such as gender.
You're right, but Winan told us that this is a mid-sized table with probably less than 10% deleted records. In most cases, it is a good situation to use the deleted() tag. Of course, we asked Winan to do his test and ask again if he notes some performance issue.
Waiting 'til may to see you at DevCon. Preparing things in advance to make the trip!