History Preferences - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cev1468860002862.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

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
  • Teradata Database — number of rows matching the query submitted. If you abort a query in progress or decline to continue after the output limit is reached, Rows shows only how many rows matched the query you submitted.
  • Other databases — number of rows returned or changed. If you abort, Rows shows only the number of rows returned.
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.