Computer scienceFundamentalsSQL and DatabasesDB TheoryCommon DB topics

Indexes

Theory

Different types of indexes

Report a typo

Match types of indexes with their description and use cases.

Match the items from left and right columns
B-Tree
Hash
Bitmap
Inverted index
Geospatial
It is used to organize full-text search in textual information
It is the most generic type of index that can be used to speedup equality, comparison and sorting operations
It is used when an attribute has a small number of distinct values compared to the total number of entries having this attribute
It is used to speedup work with geometrical and geographical data
It is based on a function that converts any database value to a numeric value
___

Create a free account to access the full topic