Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 27 Jun 2012 @ 16:53:17 GMT


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


Subj:   Re: Explain Plan differences between Static and Dynamic SQL
 
From:   Md, Asifuddin

Mark:

One additional thing - I missed out is if you have tuned your cost profile earlier in old release and you would like to impose similar rules - you might have to try doing that.

In your case, Skewing and performance issues mostly looks to be some kind of imbalance(at schema) due to change in configuration(w.r.t amps) and shortcoming of any additional stats/indexes.


Thank you,

Asif
TD gsc



     
  <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: 28 Jun 2020