Query Results - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
fey1467302953244.ditamap
dita:ditavalPath
2206_User_vp_1600_NEW.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

Query results are displayed in a table below the query box. You can view, pin, or export query results, as well as view SQL statements, Explain steps, and blocked query information.

Query Tabs
Display detailed query results in separately numbered tabs. Pinned query tabs show stored results temporarily for the current session. You can pin or unpin query results to be stored in the current session.
Submitted Statement
Displays a portion of the SQL statement.
Results Tab
Displays a table of query results that can be exported.
SQL Tab
Displays the entire SQL statement for the selected query.
Explain Tab
Displays Explain steps for the query, including step statistics and explain text. Only appears when a query meets certain thresholds established by the Teradata Viewpoint Administrator.
Blocked By Tab
Displays details about other queries that are blocking this query. Only appears when a query is blocked.
Export
Saves results of the currently selected Query tab to a .csv file.

For more information, see Summary Table Controls.



Results for each statement in the query appear in a separately numbered Query tab. Results for a single-statement query appear in the Query 1 tab. Results for multi-statement queries appear in additional tabs. For example, if you submit three statements, results appear in the Query 1, Query 2, and Query 3 tabs.