Archives of the TeradataForum
Message Posted: Wed, 28 Mar 2002 @ 02:48:49 GMT
| Subj: || || Re: Collect Stats on large table |
| From: || || Todd A. Walter |
I'm afraid I no longer have a copy of the R3 documentation so I cannot match exactly. However, in the Collect Statistics Guidelines
section of that book in 4.0 and 4.1 doc sets, that statement no longer exists.
You should always collect stats on NUSIs. The optimizer has little chance of properly using your indexes without stats.
For large tables with a UPI, it is not required to collect stats on the PI. This is the opposite of small tables where collecting on the
PI helps us get good sizing information on the table (Small is defined as <1000 rows per amp).