Database – Indexes, data sorting and searching improvement
In the previous post, we discussed data concurrency/consistency and figured out how to properly set the isolation level of an explicit DBMS transaction. In this new post, we will discuss the theory behind the indexes used in a DBMS to improve the data searching on a database table. Types of indexes Indexes in a database … Read moreDatabase – Indexes, data sorting and searching improvement