Tag: pseudo table lock in teradata

What is a pseudo table Lock in Explain Plan?

When you want to retrieve the rows from the table, the very first step in explain plan is the pseudo table lock on that table e.g – Type select * from <databasename>.<tablename> in the SQL assistant, and do the explain plan for this table. The very first step you see is – 1) First, we lock …

Continue reading