Interested to Buy Any Domain ? << Click Here >> for more details...
How can we optimize or increase the speed of a mysql select
query?
- 6 Answers
- 17279 Views
- I also Faced
- E-Mail Answers
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 the current stable version of php? What advance thing in php7?
Name and explain five of the PHP error constants?
What is php dependency injection?
What are the advantages of triggers in php?
What is substr in php?
What are the three classes of errors that can occur in php?
How big is nvarchar max?
Write down the code for save an uploaded file in php.
How can we know the total number of elements of Array?
Can I learn laravel without php?
How do you pass a variable by value?
Tell me can you extend a final defined class?
What is the use of htmlentities in php?
What is the difference between abstract class and interface in php?
Tell me what are the correct and the most two common way to start and finish a php block of code?
