The following scripts are available for the Maintenance Task Scheduler.
| Script Name | Description |
|---|---|
| starteam_sqlserver_create_sp_update_stats.sql | Updates query optimization statistics. Updating statistics ensures that queries compile with up-to-date statistics. Can be run online or offline. |
| starteam_sqlserver_create_index_maintenance_script.sql | Rebuilds indexes. Scheduling this script requires an edition of
Microsoft SQL Server that supports online index rebuilding. If not supported but scheduled, there will be an exception in the log when running
it.
Clustered indexes are rebuilt using the online option. To rebuild clustered indexes, the offline version should be executed whenever significant amounts of data is in the server. It is always possible to run it offline by clicking Execute. |
| Script Name | Description |
|---|---|
| starteam_postgres_create_compute_stats.sql | Updates query optimization statistics. Updating statistics ensures that queries compile with up-to-date statistics. Can be run online or offline. |
| starteam_postgres_create_index_maintenance_script.sql | Rebuilds indexes. Can be run online or offline. |
| Script Name | Description |
|---|---|
| starteam_oracle_create_compute_stats.sql | Updates query optimization statistics. Updating statistics ensures that queries compile with up-to-date statistics. Can be run online or offline. |
| starteam_oracle_create_index_maintenance_script.sql |
Rebuilds indexes. Scheduling this script requires an edition of Oracle database that supports online index rebuilding. (Currently Oracle Enterprise Edition only.) If not supported but scheduled, there will be an exception in the log when running it. It is always possible to run it offline by clicking Execute. |