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

How can you change the password of a mysql user?

0 Answers  


Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

0 Answers  


What is user in mysql?

0 Answers  


Write a query to display current date and time?

0 Answers  


What is the use of mysqli_query?

0 Answers  


How do you determine the location of mysql data directory?

0 Answers  


What is A BI Ap;plication?

1 Answers   HCL,


What is blob and clob?

0 Answers  


What is the latest version of mysql?

0 Answers  


How can you retrieve a particular number of records from a table?

0 Answers  


What are procedures in mysql?

0 Answers  


I have two sql database at different PC.how can link b/w database and database tables.

2 Answers  


Categories