Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 29 Sep 2014 @ 22:00:07 GMT


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


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

<-- Anonymously Posted: Monday, September 29, 2014 15:42 -->

Stats on TR_PRPTY_TRGR must not be the same in Test vs Prod.

In the first SUM step, Test estimates 10x as many rows with NO confidence vs Prod with at least LOW confidence in a smaller number.



     
  <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