Please enable JavaScript.
Coggle requires JavaScript to display documents.
Indexes - Coggle Diagram
Indexes
Types
B-Tree Indexes
The general idea of a B-Tree is that all the values are stored in order, and each leaf page is the same distance from the root
Hash Indexes
A hash index is built on a hash table and is useful only for exact lookups that use every column in the index
Spatial (R-Tree) Indexes
Unlike B-Tree indexes, spatial indexes don’t require your WHERE clauses to operate on a leftmost prefix of the index. They index the data by all dimensions at the same time
Full-text indexes
Fulltext is a special type of index that finds keywords in the text instead of comparing values directly to the values in the index
-
Multicolumn Indexes
When you include more than one column in an index, it's referred to as a composite or multicolumn index.
Covering Indexes
An index that contains (or “covers") all the data needed to satisfy a query is called a covering index
Clustered Indexes
The exact details vary between implementations, but InnoDB’s clustered indexes actually store a B-Tree index and the rows together in the same structure
-
-