Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Query performance issue - running long
 
From:   Usenko, Yuriy

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 [email protected] 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019