This is misleading. You do not lock a table. Each record in a relational database is usually stored in a group called a page. A Page is the fundamental unit of storage for relational databases and is usually somewhere between 8 to 16 kilobytes in size. That’s what gets locked, not the entire table. And if it’s a read, you’re only locking updates. Others operations can read that page concurrently.