Please enable JavaScript.
Coggle requires JavaScript to display documents.
Indexes - Coggle Diagram
Indexes
Types
B-trees
Could be used for such query types
Full value
Leftmost prefix
Column prefix
Range of values
One part exactly and a range on another part
Index only queries
R-trees
Hash indexes
Prefix indexes
Mulicolumn indexes
Clustered indexes
Covering indexes
Storaging strategies
B-trees
InnoDB
Index
Primary
Unique
Fulltext
R-trees
Spatial Data Types
Hash
Memory tables
Index creation
Clustered
Non-clustered
Index security