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

Last updated 2 years, 8 months ago | 410 views 75     5

Tags:- MySQL

MySQL |  Increase the speed of a MySQL select query

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

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