Cleaning up the History table
Delete specific History rows by highlighting them in the History window and pressing the Delete button.
Use the Cleanup History dialog box to delete a large number of rows. This dialog box allows you to specify which rows to delete based on criteria such as the Date on which the query was executed and the Data Source against which the query was executed.
If multiple criteria are entered, only the rows matching all the criteria are deleted.
This dialog box can also be used to delete all duplicate rows from the History table.
Rows are considered to be duplicate if both the Data Source and the SQL Text are an
exact match.
This option is independent from the criteria specified above.
Note: This function might take a long time if there are many rows in the History table.
To Clean the History table
1 Select the History window.
2 Right-click in the History window and select Cleanup History.
3 Set the cleanup criteria as needed. Table 32 explains the available options.
Cleanup History Option |
Description |
Date |
Enter a date or click the down arrow to display a calendar to select. Place a filter operator (>, <, =,) in the operator box. |
Data Source |
Enter a data source name. |
User Name |
Enter a user name. |
SQL Text |
Enter text that appears within the SQL Text of the rows to be deleted. Note: See also “Using Wildcard Characters with the History Filter” on page 144. |
Notes |
Enter text that appears within the Notes of the rows to be deleted. Note: See also “Using Wildcard Characters with the History Filter” on page 144. |
Queries that failed |
Select this check box to delete all rows that display an error code. |
Rows with an empty Notes column |
Select this check box to delete all rows that do not have a Note assigned. |