Archives of the TeradataForum

Message Posted: Tue, 15 Apr 2003 @ 22:03:19 GMT

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

Fixed in 4.1.0. Create Index requires a read lock on the table as of 4.1. And only a brief lock on the dictionary at the end.

Of course if you drop the index during the load, then queries running during that time that require the index will have unpredictable response times.

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