Drop Empty Index Values Tables

The Drop Empty Index Values Tables maintenance task allows to remove tables with empty index values, to speed up the partition creation. This task is recommended if you update a database created in the previous version of the application.

To drop tables with empty index values

To drop tables with empty index values

  1. On the Navigation Tree, click Report Warehouse, then click Maintenance and select Maintenance Tasks.

  2. Click clip0002 on the Maintenance Tasks page. The Maintenance Task page appears.

  3. Configure a maintenance task, making sure to select the Drop Empty Index Values Tables option from the Task Type drop-down list.

  4. Click Save.

  5. On the Navigation Tree, click Report Warehouse, then click Maintenance and select Maintenance Processes.

  6. Click clip0002 on the Maintenance Processes page. The Maintenance Process page appears.

  7. Configure a maintenance process, making sure to assign the maintenance task you just created to it.

  8. Schedule the process to run, or run it manually by clicking Run Now on the Maintenance Process page.

When the process is executed, the maintenance task runs and all tables with empty index values are removed from the database.