Chapter 10 – Locking
“If you are planning for a year, sow rice; if you are planning for a decade, plant trees; if you are planning for a lifetime, educate people."
The Four Major Locks of Teradata
There are four locks used in the Teradata Database, and they are the Read, Write, Exclusive and Access Locks. This is an important concept that will soon have that bright light bulb in your brain lighting up.
The Read Lock
When a user runs an SQL Select statement, then Teradata automatically places a read lock on the table being selected ...