effective use of indexes in mysql

Hi,
To optimize our queries we can use indexes. Can you please guide me how I can use indexes effectively. Do I deed to create indexes for the fields most used in where clause?