Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 04 Apr 2010 @ 07:46:26 GMT


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


Subj:   Re: Performance Tunning and Explain
 
From:   Anomy Anom

<-- Anonymously Posted: Sunday, April 04, 2010 01:57 -->

I would recommend you to start with exploring statisitcs on the column. As I see there is no confidence step in step(3) of explain.

Below sequence will give High confidence recommendations.

     Diagnostic helpstats on for session;
     Explian 

It also shows other low confidence steps. But start with High confidence ones. Collect those statisics.

Once you are done with it. See if any join column miss any statistics and does any of the multi-column steps are necessary.



     
  <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