Archives of the TeradataForum

Message Posted: Tue, 08 Dec 2009 @ 15:59:22 GMT

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

Collecting statistics does not make individual retrieval steps (or very simple queries) any faster.

Statistics only allow the optimizer to more accurately determine the costs for alternative join methods, retrieval methods, and execution sequences. That can make complex queries run faster, because a different access plan may be chosen.

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