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 are the features and advantages of object-oriented programming in php?
What are different types of runtime errors in php?
What is array function in javascript?
Explain preg_Match and preg_replace?
What language is php based on?
What does $_server mean?
Is it possible to extend the execution time of a php script?
Write a statement to show the joining of multiple comparisons in php?
What is the difference between $argv and $argc? Give example?
How to convert a json string to an array in php?
What is associative array in php?
What is mvc in php?
How are cookies created?
What is mean tnq
Are php session secure?