Steve,

It is better to rebuild the index from scratch, rather than simply issuing a REINDEX. You can have a routine regularly rebuild the indexes on a regular basis (such as weekly) during the downtime.

>No I have not rebuilt the index in some time. Wouldnt that really slow things down if I put that in the code?
>This application is up and running 20 hours a day 5 or 6 days a week. It creates about 60,000 records a month.
>
>I'll try a manual reindex.
>
>thanks, steve