How can we optimize or increase the speed of a mysql select
query?
Answer Posted / shanmuga
Using Proper Index.
Using LIMIT
using Primary KEy.
Important : Whenever the huge no of updation or deletion
happened in that table use OPTIMIZE TABLE command.This will
reduce the unused space.
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
What is composer json?
Why php language is used?
Write a program using while loop?
What is the difference between explode () and split () functions in php?
How to break a file path name into parts?
Is not null mysql?
How do you end a function in python?
Do you know how to declare an array in php?
Write a program using while loop in php?
How to convert a character to an ascii value?
What is php and what does it do?
What is meant by PEAR in PHP?
Tell me how to find current date and time?
Are react hooks stable?
How to find the length of a string?