| How do we can optimize or increase the speed of MySQL select query?
Below are some point which will really improve or optimize the MySQL select query:-
(1)By using Proper Index in MySQL
(2)By using the LIMIT keyword in SQL statement
(3)By using Primary Key in MySQL
(4)One important point is Whenever we have huge no of updation or deletion happened in that table we use OPTIMIZE TABLE command. This will reduce the unused space. | | |