Archives of the TeradataForum

Message Posted: Wed, 19 Sep 2012 @ 12:16:22 GMT

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

Hi.

Please check you TD version.

Please be aware - for the TD 13.10 statistics match more important when previous TD versions.

Drop all multicolumn statistics

Recollect for the all columns used for PI, PARTITION and WHERE statement.

Please analyze table where are you need full statistics and where you can collect sample statistics.

Please read TD 13.10 documentation about statistics and sampling statistics.

FYI!!

Sometimes for the query optimization do not hesitate create T@YS incident or ask local team.

System parameters for the TD13.10 will be updates special for the complicated query improvement.(huge OR, lot of derived tables etc)

Yuriy.

Teradata GTS.

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