Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Aug 2006 @ 10:50:00 GMT


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


Subj:   Re: Recommendations from Statistics Wizard
 
From:   Barrow, Martin

With regards the Collect Statistics using sample, I have tried this on a table today with the following results:

     collect statistics using sample on tab1 column (txn_dte);

     Unique Values           Column
     1,798                   TXN_DTE

The original collect statistics on the table returns less unique values:

     COLLECT STATISTICS ON TAB1  COLUMN TXN_DTE
     ;
     Unique Values           Column
     793                     TXN_DTE

Can anyone explain how the using sample in collect statistics works, I was expecting a sample to return less unique values than a full table scan.


Thanks

Martin



     
  <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