Create a simple MySQL index

Here is how you can create a MySQL index. Be aware of where you are using indexes they can be just as beneficial as they can be disastrous to performance.

ALTER TABLE table_name ADD INDEX index_name (field1, field2);