How can increase the performance of MySQL select query?
Answers were Sorted based on User's Feedback
Answer / nitin malhotra
WE CAN INCREASE THE PERFORMANCE OF SELECT STATEMENT BY USING
THE SELECTED FIELDS IN TTO THE INDEXING AND TO CHOOSE ONLY
THE FIELDS WHICH IS REQUIRED.
| Is This Answer Correct ? | 10 Yes | 0 No |
How to rename an existing table in mysql?
How do I find mysql location?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
What is the difference between char and varchar data types?
What is data type for image in mysql?
How can I see all mysql databases?
Is mysql a odbc?
What is difference between mysql and mysqli?
Use mysqldump to create a copy of the database?
What is the maximum connection pool size?
What are the different tables present in MySQL?
How to convert character strings to dates?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)