Friday, 16 September 2016

How to Know Teradata is in Pseudo table Lock

The pseudo table mechanism is a way to serially queue all table level locks through the use of an internal pseudo table. In this table the database locks the row hash of the table's table ID.
What does” Pseudo Table” Locks mean in EXPLAIN Plan in Teradata:

It is a false lock which is applied on the table to prevent two users from getting conflicting locks with all-AMP requests. PE will determine an particular AMP to manage all AMP LOCK requests for given table and Put Pseudo lock on the table.

To put in Simple terms: its like an University with 10 gates and at a given time you can enter the university through one gate ( or main gate) for security check.

2 comments:

  1. Well, this is my first visit to your blog! But I admire the precious time and effort you put into it, especially into interesting articles you share here custom essay writing service!

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete