How does a where clause work? Imagine a query select a,b from table where c=1 and d= 2;. 1. How does the optimizer decides if it wants do full table scan or index scan. 2. If...
What are gap locks?
Can we estimate a query execution time?