WE CAN INCREASE THE PERFORMANCE OF SELECT STATEMENT BY USING THE SELECTED

How can increase the performance of MySQL select query?

Question Posted / nitin malhotra

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is 'mysqlcheck'?

973

What is 'mysqlimport'?

877

How to enable or disable a row of a table using MySQL in struts?

4046

How do I install mysql?

853

How to calculate the difference between two time values?

933

What is a procedure example?

881

Is mysql a dbms?

833

How to use rank function in mysql?

932

What are the other commands to know the structure of a table using mysql commands except explain command?

967

Is mysql open source?

871

How to represent ENUMs and SETs internally?

1093

What is mysql default port number?

971

How to filter data from a mysql database table with php?

842

How do you login to MySql using Unix shell?

1117

What is the latest mysql?

899