Archives of the TeradataForum
Message Posted: Mon, 02 Jun 2008 @ 21:03:59 GMT
| Subj: || || Re: Exclusive locking with volatile |
| From: || || Dieter Noeth |
DAVID WILLIAMS wrote:
| ||We are running using the same userid and on mulitple concurrent sessions. The ETL creates and uses volatile tables with the same name in
each session.|| |
| ||Will blocking occur by exclusive locks on the DDL of the Create Volatile Table and Drop Table statement?|| |
Just explain a "create volatile table" and you'll see no locks at all:
1) First, we create the table header.
2) Finally, we send out an END TRANSACTION step to all AMPs involved
in processing the request.
The same for "drop table".