Archives of the TeradataForum

Message Posted: Mon, 21 Sep 2009 @ 13:08:42 GMT

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

One quick way to get around the stats recollection issue, which can be rather costly. If you can afford the space and I/O temporarily (depending on size of the table), and if the stats won't change drastically after the new data is inserted, updated, deleted, I think less than 10% is generally the Teradata recommended threshold, Is to use the "COPY" stats functionality of the create table table statement (V12 and up) . Also in V13 I think there is there a way to COPY stats explicitly. If anyone has used this I would be curious to know how it works/performs.

Anyway..

Ex TD V12 code:

     Create tableB as tableA with data and statistics, Delete from tableB:

     Insert into tableB.....

     Rename tableB..

     Etc...

This in effect can create state statistics, but if this doesn't cause you grief, and stats can be recollected on a weekly interval. This is sometimes a practical solution.

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