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
- 14736 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanjeev vishu
To improve select query speed we must use paging.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
What is mysqlcommand?
How many rows mysql can handle?
Explain the difference between delete and truncate.
How to filter data from a mysql database table with php?
How to upload a large file through phpmyadmin in mysql?
Is mysql connect deprecated?
Is there a way to see the files which are stored?
What is mysql and how it works?
How many rows can mysql handle?
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
What is striped backup
How to delete a database from mysql server.
Is oracle mysql free?
What is unsigned in mysql?
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
