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

Answer Posted / nikunj

For increase speed of select query, there are some factor
like...
-By using Limit in query
-By using Index on table
-By using Primary key

Is This Answer Correct ?    17 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you use an array in excel?

527


What are escaping characters?

538


What is mysql in php?

518


How to connect to mysql from a php script?

557


With a heredoc syntax, do I get variable substitution inside the heredoc contents?

637






How many functions are there in php?

517


What software is required to run php?

542


Tell me what is needed to be able to use image function?

540


What is difference between put and post method in http?

473


How to test if a variable is an array?

557


What is php compared to html?

539


List the different types of print functions available in php?

545


What percentage of websites use php?

502


Is uploaded file php?

538


Explain what are psrs?

506