The Available Partitions section of the page lists all the database partitions available for reporting. The list shows the dates covered by the partition, as well as the size and name of each partition.
Use this list to control what database partitions are included in reports, and to select individual partitions to be deleted.
Steps
-
Mark the check box in the Enable column next to each partition you want included in reports.
Use the Select all and Select none options above the list, as appropriate.
You must enable at least one partition for reporting. Use the Select none option to disable all partitions at one time so that you can enable just a
few.
Use these options to manage how much data must be analyzed when generating reports and speed report processing. For example, if you plan to generate a series of reports for
June, select only partitions with dates in June.
Important: This selection affects scheduled reports as well as reports that are run interactively. To avoid generating reports with no data, make sure the relevant
partitions are enabled when reports are scheduled to run.
-
Click the Delete option beside a partition name if that partition is no longer needed. The partition is actually deleted the next time the nightly database
maintenance job runs.
Warning: Use this option with care. You cannot recover data from deleted partitions.
Deleting obsolete partitions minimizes the number of partitions in the Log Database, which improves database and reporting performance. Use this Delete option to delete
individual partitions as needed. See Configuring maintenance options if you prefer to delete older partitions according to a schedule.
-
Click OK to activate changes to the available partitions options.