adspace


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 / dinesh goyal

By using LIMIT we can improve speed.

Is This Answer Correct ?    5 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which statement is used in a select query for partial matching?

1247


What is the current mysql version?

1105


How to Change a users password from unix shell.

1223


What is current version of mysql?

1084