Archives of the TeradataForum
Message Posted: Thu, 08 Feb 2001 @ 08:08:37 GMT
| Subj: || || Re: Collect Stat |
| From: || || Dieter Nöth |
| ||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.