indexes in mysql will increase the speed of your mysql queries.
indexes are doing cloumn basis.
for example if you have table with following fields
ID,jobdescription,salary
In this case to speed up the queries with jobdescription. then create an index for jobdescription.
CREATE TABLE mydoubts_data (
jobdescription varchar, INDEX (jobdescription),
salary INT(50),
)