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 / kalaivani
select the required field from the table
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to get last inserted id after insert data from a table in mysql?
Write a query to fetch common records between two tables using mysql?
What is append query?
Write a query to create a database and a table?
what is constraints? Also explain the different types of constraints?
How do I setup a mysql database?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
How can we get total number of records by query in mysql?
What is a select query?
Where is the mysql database stored?
Where’s database data actually stored?
How to use 'mysql' to run sql statements?
How do I enable mysqli extension?
What is the difference between char and varchar in mysql?
What is table level locking in mysql?