Archives of the TeradataForum
Message Posted: Tue, 06 Feb 2001 @ 21:01:31 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|