Hi Sherry,

Sounds like you are suffering from the dreaded cdx bloat which happens every time you issue a REINDEX.

Best to DELETE TAG ALL and re-create the index from scatch.

Regards
Doug Johnston


>Fred:
> I just did a test: I copied the .dbf file from the production to the development area and ran the app.. It speed was very slow. I import the records from the production area to the table in the development area the sql statement ran a lot faster. We do reindexing nightly. Do you know what causes that?? thanks.
>sherry