1.Select <fieldname> from tablename. 2.Limit Setting. 3.Index Using

How can we optimize or increase the speed of a mysql select
query?

Question Posted / senthilkumar

Answer Posted / senthilkumar

1.Select <fieldname> from tablename.
2.Limit Setting.
3.Index Using
4.Primary key..

Is This Answer Correct ?

13 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to write in a file in php?

1059

Why does sql injection happen?

1056

How many types of functions are there in php?

1247

Explain the difference between mysql_connect and mysql_pconnect?

968

What is repository in php?

1062

What is the default session time in php?

1079

What is PHP's configuration file called?

1229

Do you know what is use of count() function in php?

1053

What is the difference between "echo" and "print" in php?

961

How to redirect https to http url and vice versa in .htaccess?

1044

What the use of var_dump()?

1097

What are the difference between abstract class and interface in oops?

1063

What are php libraries?

978

What exactly is PHP?

1060

Tell me how comfortable are you with writing html entirely by hand?

981