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...

A select query over a large table runs very slow because of
the growing number of entries in that table. What different
measures could be taken to improve speed?

Answer Posted / sanjeev vishu

To improve select query speed we must use paging.

Is This Answer Correct ?    4 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which datatype is used for email in mysql?

1003


How to enter binary numbers in sql statements?

1008


What is meant by sharding?

986


Can you tell few best practices to be followed for optimization in sql?

973


What is the return type of mysqli_query?

919


What is insert query in mysql?

951


What is delimiter in mysql trigger?

995


What is trigger in mysql with example?

969


What is mysql57?

969


What's new in mysql 8?

1039


What is the password of mysql?

1013


Can you tell the difference between ereg_replace() and eregi_replace()?

1083


Is mysql same as mariadb?

947


What is cast in mysql?

951


What is a mysql server?

1029