Statistics in Teradata

Database

Statistics in Teradata


can any one please explain me the breif idea about the statistics, their usage and the purpose in details in teradata point of view?

4 REPLIES
SN
Enthusiast

Re: Statistics in Teradata

hi,

just an excerpt from one of the reference manuals - refer manuals for detailed undestanding of statistics

- The purpose of collecting statistics is to compute statistical data that the
Optimizer uses to optimize table access and join plans. The computed statistical
data is retained in a synopsis data structure that is stored in the data dictionary
for use during the optimizing phase of SQL statement parsing.
Accurate demographics enable the query optimizer to determine the least
costly access and join plans for a query.
It is particularly important for the Optimizer to have accurate table
demographic information for those situations in which data to be accessed
using a column or index might be skewed.

happy reading...

Re: Statistics in Teradata

Thanks alot...

can you send me the Link where I can get the manual if its available :-)
Enthusiast

Re: Statistics in Teradata

You can find some manulas here
http://www.teradataforum.com/ncr_pdf.htm
Teradata Employee

Re: Statistics in Teradata

Teradata Documentation / Manuals
http://www.info.teradata.com