>>>Something we all should be doing on a regular basis is rebuilding Indexes. Simply relying on the REINDEX command is not necessarily the best route to go. Ideally the Tags should be dropped and recreated from scratch. This is a problem if the Tables are referenced by a DBC and have persistent relationships / Primary Keys / Candidate Keys or if you have systems that really do run 24 by 7.
>>>
>>>For a couple of months now some of the FoxPro community’s leading luminaries have had access to a utility I created that facilitates SHARED mode recreation of Indexes. I am now looking to find additional people to put this into their production systems and who are also willing to provide testimonials.
>>>
>>>Feel free to reply either to this post or using a private message.
>>>
>>>Regards to all,
>>
>>Houston,
>>I'm curious. Not to put a damper on commercial enterprise and competition, but I thought Doug Hennig's SDT did this. Does your utility do stuff that this doesn't?
>
>I just spoke to a knowledgeable User of SDT and he is under the impression that it still does and always has required USE ... EXCLUSIVE to recreate Indexes. My utility does not need Exclusive Use - i.e. Tables can be open by other Users or Processes whilst recreating Indexes - Christof Lange described my technique as "very clever".
>
>When I got this to work I was under the impression that this was something big, alas the lack luster response here on the UT is disappointing.

Houston,

First, my apologies for not get back with you on this. Until recently I've been pretty "snowed under".

Second, from what I've seen of the code, Christof's right on-target with his analysis (as always< bg >). I'd add that I wish that I had thought of it.

Best Regards,