Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Where is mysql data stored?

0 Answers  

What does mysqli_fetch_assoc do?

0 Answers  

What is not null in mysql?

0 Answers  

Does adding an index lock a table?

0 Answers  

What is database migration in mysql?

0 Answers  

Can we store images in mysql database?

0 Answers  

How do you select a table?

0 Answers  

What is “i_am_a_dump” flag in mysql?

0 Answers  

Differentiate CHAR_LENGTH and LENGTH?

0 Answers  

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

0 Answers  

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 Answers  

What is mysql database extension?

0 Answers  

For more MySQL Interview Questions Click Here
Categories