This is an old revision of the document!
MySQL Tips & Tricks
Part of MySQL
Use Indexes
Pros: Massive increase in searching performance.
Cons: Slightly Increase in Storage Requirements. Slightly Increase on Write speeds.
Usage:
ALTER TABLE table_name ADD INDEX index_Name (column);