Archives of the TeradataForum

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

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

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>>