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?
- 5 Answers
- 15046 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the architecture models of SQL Server?
How do I change directories in mysql?
What are the functions of commit and rollback statements?
What is meant by mysqli?
How do I get a list of table names in mysql?
How to install mysql?
How to get a list of columns in an existing table?
Can varchar be primary key?
How do I exit mysql?
Does mysql case matter?
What is a trigger in mysql?
Is mysql a dbms?
How to load a csv file into a table
What is mysql slow query?
What is data directory in mysql?
