R S <[EMAIL PROTECTED]> writes: > I periodically delete older records from my table (which contains > hundreds of thousands of entries). I want to reindex the table for > more efficient access.
An index is kept up-to-date as you insert and delete records, so there is generally no need to re-index. If you want to recover the file space formerly used by now-deleted records, you can periodically issue the VACUUM command. Derrell
