Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 25 May 2006 @ 14:36:52 GMT


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


Subj:   Re: Optimizer makes erroneous estimate of table size...
 
From:   Michael Larkins

I have not seen a table definition (PI) nor the COLLECT that you are using, but my guess is that you are collecting statistics on multiple columns. My experience with multi-column statistics seem to indicate they are based on the combinations of values in the columns and not the number of rows. This may be what you are experiencing.


Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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