Archives of the TeradataForum

Message Posted: Tue, 08 Jul 2008 @ 14:50:49 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

In Teradata you decide what statistics to collect. There is no general statement like the one you mention below and there is no need to delete the stats prior to recollecting them. Use the COLLECT STATISTICS statement to collect stats on the index of the table. It would also help to collect stats on columns or multi columns that might be used to join to the table other then the primary index. If no stats are collected at all on the table the optimizer will take a random amp sample of the table and use those statistics to create its execution plan. If stats are collected on the table be sure to keep them up to date. Recollect when the table changes by 5% in some way. New rows added, or old rows removed for example.

Hope this helps.

Tony

	<Prev	Next>		<<First	<Prev	Next>	Last>>