1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

How can increase the performance of MySQL select query?

Question Posted / pranab

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 to show all records starting with the letters 'sonia' and the phone number '9876543210'

0 Answers  

What is the difference between b-tree and hash indexes?

0 Answers  

When to use order by in delete statement?

0 Answers  

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers  

How show all tables in mysql query?

0 Answers  




Explain advantages of MyISAM over InnoDB?

1 Answers  

How to delete an existing column in a table?

0 Answers  

How many rows can be inserted in mysql at a time?

0 Answers  

How to display nth highest salary from a table in a mysql query?

0 Answers  

How can we store binary data in mysql?

2 Answers   HP,

What are the technical features of MySQL?

0 Answers  

How to delete a trigger in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories