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

Last updated 2 years, 4 months ago | 307 views 75     5

For increaseing the speed of a query we have to do couple of things

  • First of all instead of using select * from table1, use select column1, column2, column3.. from table1.
  • Try to introduce index in the table.
  • Always use limit keyword if we are looking for any specific number of rows from the result set.