CODEWITHSUNDEEP
sqlstatisticshistogramteradata
Rocketq
Rocketq

Reputation: 5791

Teradata: How to view data distribution within the column in a table?

I would like to get some kind of histogram of data distribution in column in order to understand statistic problems.

The first step is to get total information:

help stats tbName;

For sure it is not enough, I will just get number of unique values. So how can I further investigate data distribution?

Upvotes: 0

Views: 2326

Answers (1)

dnoeth
dnoeth

Reputation: 60482

SHOW STATS VALUES COLUMN myCol ON myTable;

returns all details about histograms and biased values.

For multi-column stats:

SHOW STATS VALUES COLUMN (myCol1, myCol2) ON myTable;

For all stats defined on a table:

SHOW STATS VALUES ON myTable;

Upvotes: 2

Related Questions