Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Sep 2014 @ 20:39:38 GMT


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


Subj:   Re: Same query - Different Explains
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, September 26, 2014 14:39 -->

Note that two tables in TST are 100% of size in PRD, one about 50%, the remaining two more like 10%. And in PRD, ACCT is largest at nearly double CUBE_ROW; while in TST CUBE_ROW is 50% larger than ACCT. Those are huge differences in relative sizes, so one should not be at all surprised that EXPLAINs differ.

The question you really seem to be asking is "How can I make the TST EXPLAIN just like the PRD one?" At a minimum you would need to copy the stats - not just stats on same columns, but actual collected stats values.

Or maybe the question is only "How can I make TST perform well?" Since the data demographics are entirely different, you may need stats on different (combinations of) columns to get good performance.



     
  <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: 15 Jun 2023