How can increase the performance of MySQL select query?

Answers were Sorted based on User's Feedback



How can increase the performance of MySQL select query?..

Answer / chandresh modi

By using Limits

Is This Answer Correct ?    15 Yes 3 No

How can increase the performance of MySQL select query?..

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 can increase the performance of MySQL select query?..

Answer / david

delete all index

Is This Answer Correct ?    3 Yes 15 No

Post New Answer

More MySQL Interview Questions

When to use order by in delete statement?

0 Answers  


What are ddl statements in mysql?

0 Answers  


What is mysql good for?

0 Answers  


Why do you think it is advised to not to use guid and character columns as clustered index arrays?

0 Answers  


What is a session in mysql?

0 Answers  






Is mysql same as mariadb?

0 Answers  


What is the latest version of php and mysql?

0 Answers  


What is data node in mysql cluster?

0 Answers  


What is inner join in mysql?

0 Answers  


How do I download mysql?

0 Answers  


What is delimiter in mysql trigger?

0 Answers  


What is mysql used for?

0 Answers  


Categories