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".
Dieter
| 
