Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 Jun 2003 @ 16:40:35 GMT

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

Subj:   Re: Statistics didn't change
From:   Maeva Cohen

I tried with another DB2 tool "getstats" to collect statistics. this tool allows to collect statistics directly on the nicknames. So we do not need to drop and re create nickname after "collect statistics" to re-populate them.

And with this tool, I obtained the good results (100 rows). So why Teradata doesn t send statistics when I used the other way (drop nicknme, collect statistics on the table, re create nicknames)?


  <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