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 is composer json?

905


Why php language is used?

978


Write a program using while loop?

1026


What is the difference between explode () and split () functions in php?

1120


How to break a file path name into parts?

972


Is not null mysql?

970


How do you end a function in python?

1010


Do you know how to declare an array in php?

971


Write a program using while loop in php?

994


How to convert a character to an ascii value?

1119


What is php and what does it do?

1059


What is meant by PEAR in PHP?

973


Tell me how to find current date and time?

1044


Are react hooks stable?

934


How to find the length of a string?

958