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 |
| ||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
Or all the 5 columns needs to be used in the where condition everytime?