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

-Chinese Proverb

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

Get V14 Certification: Teradata Basics now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.