VALUES clause in COLLECT STATISTICS and SHOW STATISTICS

Database
Enthusiast

VALUES clause in COLLECT STATISTICS and SHOW STATISTICS

Hi,

 

What is the use of VALUES clause in COLLECT STATISTICS and SHOW STATISTICS statements?

2 REPLIES
Teradata Employee

Re: VALUES clause in COLLECT STATISTICS and SHOW STATISTICS

SHOW STATISTICS VALUES allows you to see the detailed stats info rather than just the summary info displayed by HELP STATISTICS.

 

 

Enthusiast

Re: VALUES clause in COLLECT STATISTICS and SHOW STATISTICS

Hi,

The VALUES clause shows you the histogram information of each column for which you have statistics collected. I use them often to compare the estimations i see in the execution plan against the histograms in order to find out why a certain join or retrieve step is chosen by the Optimizer.

Best Regards,
Roland



Roland Wenzlofsky