Archives of the TeradataForum

Message Posted: Sat, 09 Nov 2013 @ 09:44:21 GMT

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

For UPI, I would think random sampling should give optimizer almost accurate information and prepare best cost based plan.

Short answer, I would not collect stats on UPI (especially in your case as all columns are part of SQL - joining or residual condition).

Best,

Vinay Bagare

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