E
x
c
e
l
P
T
P

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

March 4, 2014

  1. first of all instead of using select * from table1, use select column1, column2, column3.. from table1
  2. Look for the opportunity to introduce index in the table you are querying.
  3. use limit keyword if you are looking for any specific number of rows from the result set.