Granularity of Locks

Granularity of locks refers to the level of detail at which database locks are applied to control concurrent access. It ranges from fine-grained locks (like individual rows) to coarse-grained locks (like entire tables). Fine-grained locking allows more simultaneous access but requires more management, while coarse-grained locking simplifies control but reduces concurrency. Choosing the right granularity balances performance and data integrity, ensuring efficient access while preventing conflicts during data operations.