Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 12:43:53 GMT

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

Based upon my direct experience, I would recommend collecting statistics on the PI (regardless of UPI or NUPI), the individual columns that comprise the PI, any column used in a join operation, and any column referenced in a WHERE clause. I have seen drastically improved query performance when these steps are taken.

-Jackson

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