Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 20 Jun 2003 @ 00:45:16 GMT


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


Subj:   Statistics didn't change
 
From:   Maeva Cohen

Hi,

I work with federated systems.

I did a sample test: I created two tables with the same datas (integer, char), 100 rows each, in each data sources (DB2, Oracle, Sybase, MsSql, Teradata etc...) and do a simple join between the two table.

And I compare explain plans.

After, I executed "collect statistics on column" then "collect statistics on table" . I re populated my nickname. I compare the new explain plans, but for Teradata, nothing has changed!!! Teradata after gathering statistics still thinks I have 1000 rows (I only inserted 100 rows).

Could you explain me why teradata doesn t collect the statistics? Why everything is equal before and after collect statistics?


Thanks,

Maeva.



     
  <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: 27 Dec 2016