>You were absolutely right. I am going to take deleted() off of the tables that will never contain deleted records.
>
>Thank you so much!!!!!
Dawn, the new conventional wisdom is that you should be skeptical of the DELETED() index EVEN when there ARE deleted records in the table.
Experiment.
Peter Robinson
Peter Robinson ** Rodes Design ** Virginia