Archives of the TeradataForum
Message Posted: Wed, 19 Sep 2012 @ 12:16:22 GMT
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.
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)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|