How RDS works-index of the query optimizer (translated from the Coding-Geek Article ),

How RDS works-index of the query optimizer (translated from the Coding-Geek Article ),

This article is translated from the Coding-Geek article: How does a relational database work. Link: http://coding-geek.com/how-databases-work/#Buffer-Replacement_strategies

This article translates the following chapters to introduce the index of the database query optimizer:

Indexes-Index

We have already talked about indexes in Section B + tree ). The only thing to remember is that the index is sorted.

Of course, there are other types of indexes, such as bitmap indexes. They are different from the B + tree in terms of CPU, I/O, and memory consumption.

In addition, many modern databases provide the ability to dynamically create indexes. If creating an index increases efficiency, the database creates a temporary index for a query.