Archives of the TeradataForum

Message Posted: Fri, 02 Oct 2015 @ 21:39:29 GMT

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

<-- Anonymously Posted: Friday, October 02, 2015 11:13 -->

Hi,

Is it possible to drop PI from an empty table in Teradata, then load data to it and then build the Primary index on the table ?

I have not tried it out. But I think this is not possible and to do that we need to drop the table first, recreate it with the NO Primary Index clause, load the data and then add PI to it ?

Please advise.

Thanks

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