A select query over a large table runs very slow because of
the growing number of entries in that table. What different
measures could be taken to improve speed?
Answer Posted / sanjeev vishu
To improve select query speed we must use paging.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
Which datatype is used for email in mysql?
How to enter binary numbers in sql statements?
What is meant by sharding?
Can you tell few best practices to be followed for optimization in sql?
What is the return type of mysqli_query?
What is insert query in mysql?
What is delimiter in mysql trigger?
What is trigger in mysql with example?
What is mysql57?
What's new in mysql 8?
What is the password of mysql?
Can you tell the difference between ereg_replace() and eregi_replace()?
Is mysql same as mariadb?
What is cast in mysql?
What is a mysql server?