Archives of the TeradataForum

Message Posted: Thu, 21 Nov 2002 @ 14:07:44 GMT

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

The first one applies the access lock when any SQL references the view. The second one only applies the access lock when the view is replaced. You can verify this by issuing an "EXPLAIN SEL * from xxxx".

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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