Please enable JavaScript.
Coggle requires JavaScript to display documents.
Indexes Basics - Coggle Diagram
Indexes Basics
Indexing Strategies for High Performance
Isolating the Column
“Isolating" the column
Prefix Indexes and Index Selectivity
prefix of the column
Multicolumn Indexes
Multicolumn
Clustered Indexes
B-Tree index and the rows
Covering Indexes
contains all the data
Types of Indexes
B-Tree Indexes
stores in order
Hash Indexes
exact lookups
Spatial (R-Tree) Indexes
indexes all dimensions
Full-text indexes
finds keyword
Indexes Overview
Easy search
Basics of Index Creation
basic syntax