Query Development | History Preferences | Teradata Studio/Studio Express - History Preferences - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Teradata Studio
Release Number
September 2022
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Exclude Options for History Database

Option Description
Exclude Explain and Dynamic Explain Statements Select the check box to exclude EXPLAIN and DYNAMIC EXPLAIN statements in the History database.
Exclude Unsuccessful Queries Select the check box to exclude unsuccessful queries from being entered in the History database.

History Options

Option Description
Limit History View Rows Enter the maximum number of rows allowed to display in the Teradata SQL History view.
Maximum Text Display Length Enter the maximum number of characters that can be displayed in a row.
Derby Database Location Displays the location of the SQL history file. To change the location, click Browse and navigate to the desired location.

History View Columns Settings

Use action buttons to select and move columns between the Columns Shown panel and the Removed Columns panel.
Column Actions Description
Remove Removes the column you select from the Columns Shown list.
Remove All Removes all columns shown in the Columns Shown list.
Add Moves a column from the Removed Columns list to the Columns Shown list.
Add All Adds all columns in the Removed Columns list to the Columns Shown list.
Up Moves a selected column one position up in the list.
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 view the complete message, hover your mouse over a cell in the Result column.
Row Count
  • Vantage – 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