Query Results

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K

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.