Archives of the TeradataForum

Message Posted: Tue, 18 Mar 2003 @ 14:23:06 GMT

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

Yes, UPI is the direct path if you run query with 'equals to something' for all columns of UPI.

If you use range constraint query (e.g. <,>, between), it's better that you collect stats on UPI.

Regards

Sergio Azzaretti

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