All Forums Database
Suganthy J 2 posts Joined 07/08
29 Jul 2008
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?

SN 77 posts Joined 01/07
29 Jul 2008

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 theOptimizer uses to optimize table access and join plans. The computed statisticaldata is retained in a synopsis data structure that is stored in the data dictionaryfor use during the optimizing phase of SQL statement parsing.Accurate demographics enable the query optimizer to determine the leastcostly access and join plans for a query.It is particularly important for the Optimizer to have accurate tabledemographic information for those situations in which data to be accessedusing a column or index might be skewed.happy reading...

Suganthy J 2 posts Joined 07/08
12 Aug 2008

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

atadaret 9 posts Joined 08/08
13 Aug 2008

You can find some manulas herehttp://www.teradataforum.com/ncr_pdf.htm

Fred 1096 posts Joined 08/04
13 Aug 2008

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

You must sign in to leave a comment.