Archives of the TeradataForum

Message Posted: Fri, 18 Feb 2005 @ 14:15:11 GMT

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

We have Locking For Access in all our views so I am not sure what you would see in cases where this statement is not in the view:

example,

     explain
     sel   *
     from  dbc.tables
     ;

             1) First, we lock DBC.dbase for access, and we lock DBC.tvm for
                access.
             2) Next, we execute the following steps in parallel.
           .... More stuff....

The first step indicates which tables are locked. This works even if you have nested views.

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