How can we optimize or increase the speed of a MySQL select query?

Answer

• first of all instead of using select * from table1, use select
  column1, column2, column3.. from table1
• Look for the opportunity to introduce index in the table you are
  querying.
• use limit keyword if you are looking for any specific number of
  rows from the result set.