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
How to create table with same structure of student table in mysql?
How to Change a users password from unix shell.
How can you export the table as an xml file in mysql?
Can you rename a database in mysql?
What is difference between statement and preparedstatement?
How can we convert between Unix & MySQL timestamps?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
How do I copy a table in mysql?
What is cursor in mysql?
Can I copy mysql data directory?
What is the difference between the LIKE and REGEXP operators?
Can we rename database in mysql?
Why do we use views instead of tables?
How do I disconnect mysql workbench?
What is 1nf 2nf 3nf?