Archives of the TeradataForum

Message Posted: Tue, 06 Feb 2001 @ 21:01:31 GMT

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

Hi Sudarsan:

I am not exactly sure of what you are attempting to speed up. However, here is a thought:

The first couple of times that you collect "new" statistics on a table, the AMPs must read every row and take its demographics using a full table scan. However, after you have once collected various column and index statistics, all you need do is issue this command:

COLLECT STATISTICS ON ;

It will then read all the rows one time and collect all the statistics. This will great improve performance over recollecting each statistic individually.

Also, in V2R4, you can do COLLECT STAT ON ;

I am not sure this is what you are looking for, but I hope it helps.

Regards,

Mike

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