A Tale of 2 Weeks
Data Structure that improves the speed of data retrieval operations on database table.
Index columns that you use for searching, sorting, or grouping.
Take advantage of leftmost prefixes.
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