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 many columns can be used for creating Index?

1098

How to analyze tables with 'mysqlcheck'?

1263

What is the phantom problem?

1043

How we can create index in mysql?

1019

How many sql dml commands are supported by 'mysql'?

1025

What is database clustering in mysql?

1088

What is the difference between procedure and function in mysql?

1070

What is triggers?

1007

What are the common mysql functions?

999

What is the difference between b-tree and hash indexes?

1054

Is there a way to see the files which are stored?

1010

What is pdo mysql?

980

change column name and make a unique column so we get no dupes.

1018

How can I see mysql database?

950

How do I assign a variable in mysql?

1050