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

How will you export tables as an xml file in mysql?

929

Can mysql handle big data?

960

What are the drivers in MySQL?

1464

State the differences between mongodb and mysql.

1185

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2128

How do you create a table in mysql workbench?

934

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

1388

Write a query to create a database and a table?

911

What does mysql flush tables do?

973

How to write after insert event update trigger on the same table in mysql?

961

What is mysql procedure?

934

How do I get a list of table names in mysql?

926

What is 1nf 2nf 3nf?

985

How can I create database in mysql?

932

What is clob in mysql

949