Archives of the TeradataForum

Message Posted: Thu, 25 Sep 2003 @ 11:31:07 GMT

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

You can update the PI of a table. However, it is a BAD (sorry - VERY BAD) idea to do so as the data is distributed based on the value of the PI. The manual may be trying to discourage such actions. Chaning the PI value is better done as a delete followed by an insert, or similar.

Keith.

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