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

Do you know design patterns. List few?

984

Is php easier than node?

930

What is substr() in php? And how it is used?

1043

How to create a public static method in PHP?

1029

Tell me what is the definition of a session?

1041

Write a program in php to check whether a number is prime or not?

942

Can we set session value in javascript?

1047

How to create a session? How to remove data from a session?

990

What is use of header() function in php? What the limitation of header()?

968

What is the difference between overloading and overriding in php?

1035

Does php need html?

976

Is it easy to learn php?

957

How does php session work?

957

What is the difference between indexed and associative array?

1022

What is dao in php?

969