aholtzapfel Posted January 25, 2008 Share Posted January 25, 2008 I wish filemaker would create a tool that would rebuild all indexes within a file. Currently, to rebuild them you would need to either manually turn indexing off on every indexed field and then turn them all back on (completely inpractial on larger files) or recover the file (after which the file should not be used). I have seen so many problems over the years that can be traced back to an indexing problem that I feel that this would be one of the most powerfull maintainence tools that could be given to us. Link to comment Share on other sites More sharing options...
Lee Smith Posted January 25, 2008 Share Posted January 25, 2008 I always thought that if you saved as compacted, or smaller, that it rebuilt the indexes. Saving a compacted copy When you save a compacted copy, FileMaker Pro rewrites the entire database, fitting as much data into each block as possible. This reclaims unused space in the file and [color:blue]rebuilds the file's structure. Compacting can be time-consuming if a file is large, and might be best accomplished as an overnight task. Lee Link to comment Share on other sites More sharing options...
aholtzapfel Posted January 25, 2008 Author Share Posted January 25, 2008 No, "Save as...(compacted)" does NOT rebuild the indexes. I had thought that as well until I tried to use it to rebuild them in a file. It did not work and I had to settle for rebuilding the index manually. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5937 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now