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 / dinesh goyal

By using LIMIT we can improve speed.

Is This Answer Correct ?    5 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How large can a mysql database become?

1051


What are all the Common SQL Function?

1207


How to dump a table to a file with 'mysqldump'?

1084


How does triggers work in mysql?

1023


What is regex in mysql?

1140


How do I change directories in mysql?

948


Is mysql still relevant?

960


Is mysql query case sensitive?

1013


What language is used in mysql?

1038


Do I need to pay for mysql?

946


Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1170


What are the steps required to view your mysql database?

1139


What is mysql cursor?

933


How to insert dynamic values in mysql using php?

1184


How do I restore a mysql database dump file in linux?

1029