>Sergey, Thanks for not giving up on me. I "get it".
>
>As for the advice on adding a bunch of indexes indiscriminately, I will follow your advice of finding the slow ones and concentrating on those.
>
>I estimate there are probably no more than 20 deleted records in all the tables in my application per installation. Deletes are seldom performed. I am going to hope that means I do not need any indexes on deleted(). If that is an incorrect assumption with regard to optimization please let me know.
>
>Otherwise, I have learned a lot and I believe I have a good plan for going forward. Thanks all for the assistance.
Hi John,
The index on DELETED() is controversial topic. See
http://fox.wikis.com/wc.dll?Wiki~NonDiscriminatingIndex.
Handling of indexes for deleted records also changed in VFP9. See
http://msdn.microsoft.com/library/en-us/dv_foxhelp9/html/7ecc3532-d06f-42b4-b1d0-9bed677cec90.asp
--sb--