Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / shanmuga

Using Proper Index.
Using LIMIT
using Primary KEy.

Important : Whenever the huge no of updation or deletion
happened in that table use OPTIMIZE TABLE command.This will
reduce the unused space.

Is This Answer Correct ?    16 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

991


What are different types of runtime errors in php?

1129


What is array function in javascript?

1081


Explain preg_Match and preg_replace?

1048


What language is php based on?

1011


What does $_server mean?

1054


Is it possible to extend the execution time of a php script?

990


Write a statement to show the joining of multiple comparisons in php?

1061


What is the difference between $argv and $argc? Give example?

1049


How to convert a json string to an array in php?

1118


What is associative array in php?

1059


What is mvc in php?

1056


How are cookies created?

1013


What is mean tnq

1601


Are php session secure?

1080