Archives of the TeradataForum

Message Posted: Thu, 23 Jun 2011 @ 18:12:26 GMT

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

If the statement is flushing the parser cache for the table, then it probably has a write lock on the table in the first step of the explain for the statement. So, if someone else was creating an index on the table, the statement would not be able to get past the step that takes the write lock until the index build has completed.

Thanks,

Barry

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