Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 31 Jan 2002 @ 15:40:25 GMT

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

Subj:   Re: What happens to Collect Stats & Metadata while exporting/archiving?
From:   David Wellman


I wouldn't have thought you needed to re-collect stats just because you've restored the table to a different configuration. The stats describe the data (number of rows, number of nulls, median values etc etc) and that information doesn't change even if the data has been restored to a different configuration. As far as I'm aware, there is nothing in the statistics information which describes the configuration of the system. Information about the number of amps etc is added in to the equation by the optimiser at run time.


Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

  <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