Archives of the TeradataForum

Message Posted: Thu, 18 Dec 2003 @ 19:49:40 GMT

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

As Table-Y already has the UPI, I would suggest you have the table retained for the best load-performance, However to improve the query performance try creating a USI/NUSI or a Single-table Join index on table-Y

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