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, if a table has one column defined as TIMESTAMP?

1002

What is difference between oracle and mysql?

914

What is an index? How can an index be declared in mysql?

883

what are the different tables present in mysql? : Mysql dba

1007

How can I insert images into a Mysql database?

1045

How to find the unique values if the value in the column is repeated?

968

What is difference between mysql_connect and mysql_pconnect?

1031

What data structure does mysql use?

993

How to determine the location of the data directory?

953

What are the limitations of mysql?

1039

How do you rename a table?

978

can you tell how can you display the maximum salary in sql? : Mysql dba

856

What is pdo mysql?

921

Explain Access Control Lists.

983

What is a deterministic function?

1061