How can we increase the speed of a MySQL select query?
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.