Allows you to select database maintenance options.
Performance options
Delete temporary symbol variations (flavors) in database
Deletes any orphan flavors in the database. These are temporary symbol variations that the software used during creation or placement of certain symbols, but are no longer necessary.
This option is unavailable if you selected a catalog, or if the selected model is a satellite.
Delete database objects that users have deleted from model
Cleans up the CoreDeletedObjects table. When you delete an object in the model, the software creates an entry for that object in the table because Drawings and Reports might still have representations of that deleted object that need to be referenced. The CoreDeletedObjects table can become quite large.
In a Global Workshare Configuration, this option is only available for the host location. This option is not available at satellite locations. The delete action made on the host is replicated one-way to the satellites.
Only delete information older than
Limits the deletion to those records whose last-modified date is less than the values you specify in this text box. This option is only available when you select Delete database objects that users have deleted from the model.
In a Global Workshare Configuration, this option is only available for the host location.
Index optimization
No optimization
Suppresses optimization of all database tables. This is the default setting.
Rebuild selected indexes
Rebuilds the indexes on the database tables for the selected tables in the grid. The software automatically determines a fill factor for the database tables. This fill factor is dependent on the activity in the database. The fill factor is low when a model is very dynamic, but the fill factor is high when modifications occur in the model (for example, in a reference or an As-Built model). Similarly, the fill factor is also low during catalog creation or heavy bulkload periods, but the fill factor is high when the catalog becomes stabilized and used in production.
Rebuilding selected indexes can be performed in a Global Workshare Configuration at the host and all satellite locations.
This option is enabled for both Oracle Standard Edition and SQL Standard Edition. In this instance, the command runs the Rebuild index in offline mode.
-
You should only use offline mode during scheduled downtime periods when there is no DML activity on the model database.
-
If you select this option but do not choose any tables in the associated grid, no action is taken.
Reorganize selected indexes
Reorganizes the indexes on the database tables for the selected tables in the grid.
Reorganizing selected indexes can be performed in a Global Workshare Configuration at the host and all satellite locations.
If you select this option but do not choose any tables in the associated grid, no action is taken.
Select
Specifies which tables are processed on the grid.
The grid is only available when you select Rebuild selected indexes or Reorganize selected indexes.
Table Name
Displays the name of each table that is available for processing.
Fragmentation Index
Displays the level of fragmentation for each table.
An experienced Oracle or SQL Server DBA may prefer to use specific database management tools to optimize indexes instead of accepting the Project Management defaults.
Select All
Selects all tables listed in the grid.
Clear All
Clears all table selections in the grid.
OK
Displays a confirmation message and then initiates the actions for database maintenance. The confirmation message advises you that the process is time intensive and asks if you want to continue. If you click Yes, the dialog clears and a progress bar displays. Selecting No cancels the command.
Cancel
Closes the Database Maintenance dialog without performing any action.
Analyze
Queries the database and displays a count of deleted and orphaned flavors.