How can increase the performance of MySQL select query?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is pdo more secure than mysqli?

666


Why mysql is used with php?

697


How do you rename a table in mysql?

732


Is mysql a server or database?

669


How many primary keys can be there in a table?

738


What can you do with mysql?

697


Where is the mysql database stored?

705


How do I start mysql client?

720


What is the phantom problem?

747


How to extract a unit value from a date and time?

714


What is a trigger in mysql?

802


Is mysql still relevant?

707


How to get help information from the server?

761


What is difference between unix timestamp and mysql timestamp?

744


What is append query?

702