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
- 14749 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the mysql database files stored in system ?
How to include character strings in sql statements?
How do I download mysql on my laptop?
What is the difference between b-tree and hash indexes?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
How to create trigger in mysql phpmyadmin?
How does mysql store data?
What is the use of count function in mysql?
What is mysqli_result?
Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T
How to store binary data in mysql?
How to create trigger in mysql workbench?
How do I run mysql without installing?
How to display nth highest salary from a table in a mysql query?
What is memory table in mysql?
