Exclude Options for History Database
Select one or more of these options to exclude in the Teradata SQL History database:
Option | Description |
---|---|
Exclude Explain Statements | Check this box to exclude EXPLAIN statements in the History database. |
Exclude Unsuccessful Queries | Check this box to exclude unsuccessful queries from being entered in the History database. |
History Rows
In Limit History View Rows, type the maximum number of rows allowed to display in the Teradata SQL History view.
History View Columns Settings
Use action buttons to select and move columns between the Selected Columns panel and the Available Columns panel.
Column Actions | Description |
---|---|
Remove | Removes the column you select from the Selected Columns list. |
Remove All | Removes all columns shown in the Selected Columns list. |
Add | Moves a column from the Available Columns list to the Selected Columns list. |
Add All | Adds all columns in the Available Columns list to the Selected Columns list. |
Move Up | Moves a selected column one position up in the list. |
Move Down | Moves a selected column down one position in the list. |
Column Options | Description |
---|---|
Timestamp | Date and time at which the query ended |
Source | Data source name |
User ID | User ID logged on |
Destination | TBW - in progress |
Result | Result message which is blank unless an error occurs. To see full message, hover your mouse over a cell in the Result column. |
Row Count |
|
Note | User note attached to query |
SQL Statement | Query text |
SQL Type | Type of database accessed |
Length | Length of the query in characters |
Statements | Number of statements in the query |
Statement Type | List of statement types used in the query, such as, CREATE TABLE, INSERT, SELECT. |
Elapsed Time | Total elapsed time for the query |
DBMS Time | Time spent within the database |
Fetch Time | Time taken to return the data |
Parameters | Number of parameters used in the query |
Sequence | Order in which the query was submitted to the database |
Actions
Option | Description |
---|---|
Apply | Click to apply your changes. |
Restore Defaults | Click to return settings to default values. |
OK | Click to save your preference settings. |