“The trouble with wedlock is that there's not enough wed and too much lock.”
- Christopher Morley
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.
When a user runs an SQL Select statement, then Teradata automatically places a read lock on the table being selected from. The user might not know or see that a Read lock has ...