 |
 |
Archives of the TeradataForum
Message Posted: Thu, 08 Feb 2001 @ 08:08:37 GMT
| Subj: | | Re: Collect Stat |
| |
| From: | | Dieter N�th |
Hi Dave,
| | Although there has always been the command to re-collect stats at the table level, until V2R4, this has always been processed as a
series of collect stats on each column and index. Each one is done serially, so there are no time savings by using this syntax. | |
| | With V2R4 (my understanding is that it is V2R4.0.0), re-collecting stats is done by a single scan of the table so this provides
significant potential time savings. | |
I just run an explain on collect stats on table level (V2R.04.00.01.13): still doing scans on each index subtable and several !!
FTS on the base table for severel non-indexed columns...
So it's still doing it serially, but it's using access locks now.
kind regards
Dieter
| |
