 |
 |
Archives of the TeradataForum
Message Posted: Sat, 09 Nov 2013 @ 22:33:34 GMT
| Subj: | | Re: Statistics on multi column UPI |
| |
| From: | | Robert Briggs |
Sravan Kumar Bodla wrote:
| | 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? | |
No, and Yes.
| |
