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

What is deterministic in mysql?

0 Answers  

How do I find the database name in mysql?

0 Answers  

How do I start mysql client?

0 Answers  

suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

0 Answers   ACC,

Is mysql a scripting language?

0 Answers  




How to get full name of monthname ?

4 Answers  

Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters

3 Answers  

Is primary key auto increment?

0 Answers  

How do I delete a row in mysql?

0 Answers  

What is a result set object?

0 Answers  

What is meant by mysql database?

1 Answers  

What are the different column comparison operators in mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories