By using LIMIT we can improve speed.

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?

Question Posted / dinesh goyal

5 Answers
14747 Views
I also Faced
E-Mail Answers

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

How do you know if your mysql server is alive?

1008

Is oracle mysql free?

841

What is procedure in mysql?

899

What is current version of mysql?

929

Is mysql case-sensitive?

853

What is join in mysql? What are the different types of join?

902

what is cte? : Mysql dba

907

What is a result set object?

926

What is memory table?

869

What is mysql routine?

874

What is the default port of mysql server?

988

Why use mysql procedures?

945

What is the current root password of mysql?

876

Is mysql same as sql?

854

What is heap table?

984