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 increase the maximum execution time of a script in php?

974

What is polymorphism?

2506

How check variable is set or not in php?

884

Applications written to provide a GUI shell for Unix and Linux are called

1054

What are the differences between session and cookie?

1014

What are the benefits of using php and mysql?

987

How do I find out the number of parameters passed into function9?

980

What is the expansion of LAMP?

1058

Explain include(), include_once, require() and require_once?

1024

What do the initials of php stand for?

1061

What is __ invoke in php?

993

What is the value for this auto incremented field user_pri_id?

932

What is the purpose of break and continue statement?

982

What is url encoding and decoding in php?

1105

Why we use get in php?

991