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

What are the rules to declare a php variables?

1067

What software is required for php?

999

Explain php explode() function.

990

What is meant by public, private, protected, static and final scopes?

1002

What is the use of "echo" in php?

923

What is the use of strpos in php?

1001

Is php used for frontend or backend?

972

Do you have to initialize variables in php?

907

What good is polymorphism?

895

Can we override static method in php?

1031

How do I sort numbers in php?

999

Which is faster for or foreach?

903

What new features php7 has in store for us?

955

What is a controller in programming?

980

How can we access the data sent through the url with the get method?

1140