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

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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?

Question Posted / pranab

Answers were Sorted based on User's Feedback



A select query over a large table runs very slow because of the growing number of entries in that ..

Answer / dhirendra

Myself also faced the problem and after indexing its
resolved.
Try to find out the feild name on which maximum query
executed. Create index on that field it will improve the
performance.
Secondly you may create archiev of you table which stores
the record which is not required and deletion or updation
activity and keep the current table light.

Is This Answer Correct ?    11 Yes 0 No

A select query over a large table runs very slow because of the growing number of entries in that ..

Answer / kalaivani

select the required field from the table

Is This Answer Correct ?    3 Yes 1 No

A select query over a large table runs very slow because of the growing number of entries in that ..

Answer / jd

This question cannot be answered with the way it is formulated.

One has to run a trace to figure out why the select is slow.
it could be a lack of index, it could be bad storage
parameters, it could be that the select itself is written
poorly.

Too many problem can be described by this symptom.

Is This Answer Correct ?    0 Yes 0 No

A select query over a large table runs very slow because of the growing number of entries in that ..

Answer / sanjeev vishu

To improve select query speed we must use paging.

Is This Answer Correct ?    4 Yes 8 No

A select query over a large table runs very slow because of the growing number of entries in that ..

Answer / dinesh goyal

By using LIMIT we can improve speed.

Is This Answer Correct ?    5 Yes 10 No

Post New Answer

More MySQL Interview Questions

How to run a sql statement?

0 Answers  

What is general log in mysql?

0 Answers  

How do you control the max size of a HEAP table?

1 Answers  

How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

0 Answers  

How do I run mysql without installing?

0 Answers  

What is MySQL?

0 Answers  

What is mysqladmin flush hosts?

0 Answers  

How to Set a root password if there is on root password.

0 Answers  

Can we use mysql and mysqli together?

0 Answers  

What is innodb_buffer_pool_size?

0 Answers  

What are the different column comparison operators in mysql?

0 Answers  

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

0 Answers   ACC,

For more MySQL Interview Questions Click Here
Categories