![](http://www.studyzone4u.com/assets/image/ads6.jpg)
How can we increase the speed of a MySQL select query?
Last updated 5 years, 10 months ago | 1580 views 75 5
![Card image](/static/app-assets/images/sz4u-cover.jpg)
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.