Example: SHOW STATISTICS SEQUENCED Option - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

This example demonstrates how to use the SEQUENCED option with a SHOW STATISTICS (Optimizer Form) request.

The following SHOW STATISTICS request displays the statistics on columns x1 and y1 from table_1 with sequence numbers.

     SHOW STATISTICS VALUES SEQUENCED COLUMN x1, COLUMN y1 ON table_1;

The request produces a wide 2-column report with the headings SequenceNumber and RequestText, where the RequestText column also reports the current detailed statistics for columns x1 and y1 from table_1.