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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is strlen function in php?

777


What is php mainly used for?

748


How check field is empty or not in php?

802


Is php free to use?

750


How can cross site request forgery csrf be prevented?

709


Explain the installation of PHP on UNIX systems?

815


If the variable $var1 is set to 10 and the $var2 is set to the character var1, what's the value of $$var2?

761


Write a program to display table of a number using php?

694


What are the features and advantages of object-oriented programming in php?

708


What is an associative array?

758


How to open a file for writing?

784


Explain me the difference between include and require?

729


What is php and sql?

777


How to get the http request in php?

789


What is json php?

777