Archives of the TeradataForum

Message Posted: Mon, 17 Nov 2003 @ 14:11:10 GMT

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

Did you try adding a LOCK FOR ACCESS prefix naming the Join Index to the users' view of the table, in addition to the one for the table itself? You are not limited to objects explicitly referenced in the SELECT statement(s).

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