VALUES clause in COLLECT STATISTICS and SHOW STATISTICS

Database
N/A

VALUES clause in COLLECT STATISTICS and SHOW STATISTICS

Hi,

 

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

  • statistics
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.

 

 

N/A

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