 |
 |
Archives of the TeradataForum
Message Posted: Sat, 09 Nov 2013 @ 19:58:48 GMT
| Subj: | | Re: Statistics on multi column UPI |
| |
| From: | | Bodla, Sravan Kumar |
Sughesh.Sumansingh wrote:
| | 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. | |
I have a question here.
If UPI is defined on 5 columns, what if only 1 or 2 columns are used in the where condition, will the query takes advantage of UPI in this
case?
Or all the 5 columns needs to be used in the where condition everytime?
Thanks,
Sravan.
| |
