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

What does blob mean in mysql?

907


What are the common mysql functions?

889


How can you create and drop view in mysql?

865


Is mysql a distributed database?

895


What is a heap table?

877


What is mysql connection limit?

880


What are the two types of queries?

886


How to convert numeric values to character strings?

978


Do I need to pay for mysql?

848


What is memory table?

852


Are stored procedures precompiled?

918


How do I show users in mysql?

984


What is mysql used for?

907


How can we change the data type of a column of a table?

938


Is oracle better than mysql?

828