PDA

View Full Version : Reindexing



almac
12-15-2010, 04:33 PM
Can anyone tell me how long reindexing takes please . I have approx 4.5 million hands and trying to figure out the best time to start it .

many thanks

Al

Patvs
12-16-2010, 02:56 AM
Which SQL version are you using?
Reindexing a 4.5 million hand database.. should take 1 - up to 5 hours.

When the reindex takes place you need a LOT of free disk space (close to the size of the database) because it will create some temp files (which it will delete after the reindex)