A Tale of 2 Weeks
Data Structure that improves the speed of data retrieval operations on database table.
- Wikipedia
B Trees
Index columns that you use for searching, sorting, or grouping.
Column Cardinality
Take advantage of leftmost prefixes.
Don't over-index.
Match index types to the type of comparisons you perform.
(Hash based/ B-tree indexing)
Try to compare columns that have the same data type
Try to make indexed columns stand alone in comparison expressions
Don't use wildcards at the beginning of a LIKE pattern
Use EXPLAIN to verify optimizer operation.
Slower Creates and Updates
More Disk Space