How can increase the performance of MySQL select query?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does mysql encrypt passwords?

488


Why do we use views instead of tables?

502


What is regexp?

660


Can you tell how to find the number of rows in a resultset using php?

477


What is the insert?

495






What is 'mysqladmin' in mysql?

527


What is int unsigned?

504


What is longblob in mysql?

528


How to dump a table from a database.

542


Can you tell which of the following where clauses is faster?

453


Can you tell what are various ways to create an index?

469


What is the datatype for password in mysql?

527


How do I truncate all tables in mysql?

492


What is query design?

473


What is the usage of "i-am-a-dummy" flag in mysql?

677