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
How does mysql encrypt passwords?
Why do we use views instead of tables?
What is regexp?
Can you tell how to find the number of rows in a resultset using php?
What is the insert?
What is 'mysqladmin' in mysql?
What is int unsigned?
What is longblob in mysql?
How to dump a table from a database.
Can you tell which of the following where clauses is faster?
Can you tell what are various ways to create an index?
What is the datatype for password in mysql?
How do I truncate all tables in mysql?
What is query design?
What is the usage of "i-am-a-dummy" flag in mysql?