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
How many groups of data types?
How do I get a list of table names in mysql?
What is the full meaning of mysql?
Is sql similar to mysql?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
How many triggers are possible in mysql?
How do I setup mysql?
What is the default port of mysql server?
What are Heap tables?
How do I grant privileges to a user in mysql phpmyadmin?
How do I use mysql?
How many primary keys can be there in a table?
What you can use regular expression for in mysql?
What is the difference between truncate and delete?
What are string data types?