Task Order in Thorough Optimization

The order and number of tasks done during the Optimize Database (Thorough) operation is different in different contexts. This page gives you the list of tasks done in the most frequently used contexts.

Manual optimization with Firebird

  1. Taking the vault offline
  2. Clearing the quick indexing table
  3. Resetting the help tables
  4. Deleting the contents of temporary files
  5. Resetting the ID generator for file uploads
  6. Changing the local time zone of the vault
  7. Rebuilding metadata indexes
  8. Recalculating relevance scores for objects
  9. Removing unused access control lists
  10. Removing old records from object type change logs
  11. Processing the full-text search compatibility of views
  12. Upgrading the vault database to improve performance
  13. Optimizing the vault database
  14. Optimizing the process memory
  15. Backing up metadata
  16. Restoring metadata
  17. Bringing the vault online
  18. Compressing the full-text search indexes

Manual optimization with Microsoft SQL Server ("Delete the files of destroyed objects" not enabled)

  1. Clearing the quick indexing table
  2. Resetting the help tables
  3. Deleting the contents of temporary files
  4. Resetting the ID generator for file uploads
  5. Changing the local time zone of the vault
  6. Rebuilding metadata indexes
  7. Recalculating relevance scores for objects
  8. Taking the vault offline
    • This step is done only if dtSearch is used as the search engine.
  9. Bringing the vault online
    • This step is done only if dtSearch is used as the search engine.
  10. Removing unused access control lists
  11. Removing old records from object type change logs
  12. Processing the full-text search compatibility of views
  13. Upgrading the vault database to improve performance
  14. Optimizing the vault database
  15. Rebuilding database indexes
  16. Updating the statistics for database objects
  17. Optimizing the process memory
  18. Compressing the full-text search indexes

Manual optimization with Microsoft SQL Server ("Delete the files of destroyed objects" enabled)

  1. Taking the vault offline
  2. Clearing the quick indexing table
  3. Resetting the help tables
  4. Deleting the contents of temporary files
  5. Resetting the ID generator for file uploads
  6. Changing the local time zone of the vault
  7. Rebuilding metadata indexes
  8. Recalculating relevance scores for objects
  9. Removing unused access control lists
  10. Removing old records from object type change logs
  11. Processing the full-text search compatibility of views
  12. Upgrading the vault database to improve performance
  13. Optimizing the vault database
  14. Rebuilding database indexes
  15. Updating the statistics for database objects
  16. Optimizing the process memory
  17. Bringing the vault online
  18. Compressing the full-text search indexes

Scheduled optimization with Firebird

  1. Taking the vault offline
  2. Clearing the quick indexing table
  3. Resetting the help tables
  4. Deleting the contents of temporary files
  5. Resetting the ID generator for file uploads
  6. Rebuilding metadata indexes
  7. Recalculating relevance scores for objects
  8. Removing unused access control lists
  9. Removing old records from object type change logs
  10. Processing the full-text search compatibility of views
  11. Upgrading the vault database to improve performance
  12. Optimizing the vault database
  13. Optimizing the process memory
  14. Backing up metadata
  15. Restoring metadata
  16. Bringing the vault online
  17. Compressing the full-text search indexes

Scheduled optimization with Microsoft SQL Server

  1. Clearing the quick indexing table
  2. Resetting the help tables
  3. Deleting the contents of temporary files
  4. Resetting the ID generator for file uploads
  5. Rebuilding metadata indexes
  6. Recalculating relevance scores for objects
  7. Taking the vault offline
    • This step is done only if dtSearch is used as the search engine.
  8. Bringing the vault online
    • This step is done only if dtSearch is used as the search engine.
  9. Removing unused access control lists
  10. Removing old records from object type change logs
  11. Processing the full-text search compatibility of views
  12. Upgrading the vault database to improve performance
  13. Optimizing the vault database
  14. Rebuilding database indexes
  15. Updating the statistics for database objects
  16. Optimizing the process memory
  17. Compressing the full-text search indexes