Archives of the TeradataForum
Message Posted: Sat, 09 Nov 2013 @ 11:04:14 GMT
| Subj: || || Re: Statistics on multi column UPI |
| From: || || Dieter Noeth |
| ||Table have a UPI which is composed of 5 columns.|| |
| ||Currently there is no stats on this UPI.|| |
| ||Most of queries we are expecting all these 5 columns will be used in join / where condition.|| |
If you actually use it as described you don't need stats as the optimizer knows about uniqueness due to the UPI.
And if you still want to collect stats you should never collect full stats, use SAMPLE instead.