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 do I disconnect mysql workbench?

1064


Can we write pl sql mysql?

946


What is the datatype of image in mysql?

919


How do I delete a row in mysql?

967


what is database white box testing? : Mysql dba

998


How do I setup mysql?

901


Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

975


What is InnoDB?

1100


What is delimiter in mysql trigger?

959


HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

2227


What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

1006


Why we use mysql database?

928


What are the disadvantages of stored procedures?

979


Define REGEXP?

1105


How to create trigger in mysql phpmyadmin?

1101