Posted inDB
What is MVCC?
1. What is MVCC? MVCC (Multi-Version Concurrency Control) is a method of concurrency control. Generally,…
Posted inDB
The Role and Types of Indexes
I. Introduction to Indexes 1. Concept of Indexes An index is a sorted list that…
Posted inDB
Scenarios Where SQL Indexes Fail
1. Using functions or expressions on indexed columns When performing function operations, mathematical expressions,…