>If SET DELETED is ON, you need an index on Deleted() on both table for a full optimization.
>
>HTH

Uhhh, no ;-) The file has no deleted records,
and my problem is not partial optimization,
it is *no* optimization for two fields,
Fed_TaxId and Tax_Sufx. It does do partial
optimization for the Code field.

Thanks for the response though...

...kt