Archives of the TeradataForum

Message Posted: Thu, 25 Sep 2003 @ 18:42:11 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

All,

Range predicates (like,>,<,>=,<=) will use NUSI's ?

For example I have a table with 10 columns , Col1 is UPI

SEL  * FROM
WHERE col2 = 'string'  AND
          col3 = 'rick' AND
          col4 = 12345
          col5 > 0

creating a NUSI on col2,3,4 is good or NUSI on col2,3 is good ?

Rick

	<Prev	Next>		<<First	<Prev	Next>	Last>>