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


Please Help Members By Posting Answers For Below Questions

Can we store pdf files in mysql?

464


What is mysql and mysqli?

466


What are the functions in mysql?

488


What is a join in mysql?

476


How to change a password for an existing user via mysqladmin?

555






What is the difference between truncate and delete in mysql?

526


What you can use regular expression for in mysql?

476


What is definer in mysql trigger?

490


How can I see all mysql databases?

406


If we use sum function in mysql, does it return sum of that row or for that column?

520


How to set the time zone for MySQL to particular country time?

2716


what is the difference between between and in operators in mysql?

491


How many rows we can insert in a mysql table?

483


What are procedures in mysql? Explain

519


How to create a trigger in mysql?

487