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

Last updated 3 years, 2 months ago | 604 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.