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?
- 5 Answers
- 13927 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalaivani
select the required field from the table
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How can you export the table as an xml file in mysql?
How do I kill a mysql connection?
What is information_schema in mysql?
What is sqlyog?
How do I connect to a database in mysql workbench?
How to check if value already exists in mysql database in php?
Does mysql use t sql?
How to create a new table by selecting rows from another table in mysql?
How do I create a schema in mysql?
How do I view mysql logs?
What is default password for mysql?
How many ways to get the current time?
How does limit work in mysql?
What is mysql workbench used for?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
