Best way to reindex a large database?

Hi,

I’ve created an e-mail archive spanning ~20 years. I’ve used an Applescript to extract all the attachments above a certain size and import them into DT3. I’ve also removed the attachments from the original .eml files to prevent having them all as duplicates (more info: Separate imported e-mail attachments for better search).

Because I’ve changed the original .eml files I need to reindex my database (~320.000 records / 60 GB including duplicates now). What would be the best way of doing that? Rebuild or something else? I have no problem leaving it running for quite some time but wondering if there’s a way to ‘reindex’ that wouldn’t necessarily require exporting and then importing again.

Rebuilding the database is sufficient.