Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 14 Jan 2004 @ 16:53:12 GMT

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

Subj:   Re: Collecting Statistics -- Question
From:   Claybourne Barrineau


A good compromise, if you are on V2R5, is to use the 'Collect Stats using Sample' option. This is very fast (couple of seconds.) Otherwise, if this column will always have the same value, you should be able to collect regular statistics just once, and then never collect them again (assuming you collect stats at the column level, and not the table level.)

Because random amp sampling will never result in anything better than a low confidence step, it might be beneficial for the optimizer to make us of statistics on this column if it is involved in queries which join multiple tables together.

Hope this is helpful and/or accurate,


  <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: 28 Jun 2020