How can we optimize or increase the speed of a mysql select
query?
- 6 Answers
- 16376 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 does session start do in php?
How can I use single quotes in single quotes in php?
What is difference between strstr() and stristr()?
What are the differences between php constants and variables?
What is difference between explode() or split() in PHP?
Tell me which programming language does php resemble to?
What is isset function in php?
What are some new features introduced in php7?
Is key exist in array php?
What is the maximum size of a database in mysql?
What are php magic quotes?
What is reference variable php?
What is associative array in php?
Is php 7.0 stable?
Tell me can you extend a final defined class?
