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 / kalaivani
select the required field from the table
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of mysql?
Why to use char instead of varchar in the database?
What is delimiter $$?
Is mysql query case sensitive?
How do I restore a mysql database?
How to include comments in sql statements?
How many rows can be inserted in mysql at a time?
explain GROUPBY & HAVING clause with examples.
How do I show columns in mysql?
What is 'mysqld'?
Can not connect to mysql server 10060?
How can you plan the logshipping before processing?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
What is the difference between mysql_connect and mysqli_connect?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?