Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 05 Feb 2001 @ 21:01:57 GMT

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

Subj:   Re: Collect Stat
From:   James Judge

Depends on the number of columns and cardinality of those columns; i.e. the more unique the longer it takes. So if you are only collecting on secondary indexes, NUPI's, columns used in WHERE clause criteria, UPI's of small tables (I would say small means less than 1000 rows per VAMP) then you have little else you can do. If your database level is R3 then R4 will have performance improvements. Once you have defined statistics you can re-collect all for a table by collecting statistics at the table level (i.e. without naming columns and indexes).

  <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